autonumber in a query?

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
Hi,


You can't with Jet, unless you create first a table and then use an
"append" query, rather than a SELECT query, to add the records to the table
you previously created with an autonumber.



Hoping it may help,
Vanderghast, Access MVP
 
I am wanting to create those numbers to create an accumulated field, because
I need of an I number of growing order, since I cannot do with the date
because repeats.
 

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
How do you create an autonumber column in a query? 2
Trouble with Query Results 11
Append query - Append to table with Autonumber field 2
Links in Query results 3
Create table query... want to insert autonumber column 3
Trouble with autonumber field in a query 3

Back
Top