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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query and Autonumber Fields 6
query that brings a autonumber field 6
Links in Query results 3
Trouble with Query Results 11
Append query - Append to table with Autonumber field 2
How do I make a query return just 1 record 2
Create table query... want to insert autonumber column 3
How do you create an autonumber column in a query? 2

Back
Top