Autonumber in a query

  • Thread starter Thread starter Fabio
  • Start date Start date
F

Fabio

How can I include an autonumber in a field of a query ?

Or hoe can I select just the 5 first records of my query?
 
Thank you Steve.

-----Original Message-----




If you are using the Access Autonumber type, you shouldn't display it
because it is only a way to ensure every record is unique.
If you are 'rolling you own' autonumber, just double click on the field and
it will be put in the design grid (or drag it down to a column).

In SQL view of the query, changing

Select

to

Select Top 5

will give you the the top 5 (or less) records.

HTH
Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)

.
Click to expand...
 
Back
Top