Quite simple question

[Slayboy]

I have created a query with simulated fields created to be appended to a table. However the table has an autonumber field and I need to simulate the next autonumbers in the query to append into the table.

All I need is a simulated field that starts at 1 and increments up for each record, I can then add this field to the DMax of the autonumber field in the table to generate the new autonumbers in the query.

I'm sure some kind of simple running sum or something can help me with this but I've tried loads of things off this forum and can't get any to work how I want.

 

[FloBob]

You usually do not have to worry about a true autonumber field... once you add those records they will have there numbers assigned to them. I dont think you can just assign any value to an autonumber though I have not tried it. I know for a fact that an update query or a ado , dao addnew will populate the autonumber field with the correct value. I hope this helps.