Creating a AutoInteger in a make-table query

[jrp7442]

Hey guys....Help Needed

I am trying to create a table using a make-table query. This table will sent to a text file. Howeer, I need a sequential in-file number that will keep track of the record number it is on. Does anyone have any ideas how I can tell a query to create a Counter inside itself.

Thanks,
Jason

 

[GingerR]

can you add the records to an existing table structure instead? each time deleting existing records then appending new? this way you can have a field in the existing table which is Autonum (do not include this field in your Append query).

i've found that using make table queries over and over increase the size of db a lot faster than using delete-append queries.

g