Numbering records in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I number records in a query? Example: I have a query with 20 four
records. I only want to see 20 in numerical order, without change the order
of the Name field which is Ascending?

Thank you.

NL
 
I have a query with 20 four records.
Which four do you want to not show? If it is the last four then use TOP 20
in the SQL statement.
 
I would like to number the records in order by alpha, and also have numbers
in order. How can use the numbers that show in the navagtion bar at the
bottom?
If I have two queries (from one table that has 60 records), the fist quarter
I want to show only 20 records alphabethize; the second query I want to see
the next 20 records (from 21-40) alphabetized (continuing from the first
query), so and so wi the 3rd query.
 
Back
Top