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