incrementing number (1 Viewer)

Hi all

I am adding two records to an empty table using an append query (or make table query). I would like the first record to have 1 in the ID field and the second to have 2. I will then delete 2, append 1 elsewhere and empty the table and start over again.

Any suggestions? It needs to be 1 and 2 each time not just an autonumber.

Thanks

Greg

Hi Greg
If using a MakeTable query I would have thought that autonumber would be ok since as I understand it if the query finds there is already a table of that name it deletes it and creates a new instance of it. If so, then autonumber ought to re-start from scratch.
If this doesn't work, then you could put a field, say bytNum, into the table then delete all existing records and use ADO to add new records, calling the first one bytNum = 1 and the next bytNum = 2
Might work
Good luck