Record number field that increments in a query

[Guest]

I need my query to append to an empty table and have a field that will
contain 1 for the first record, 2 for the second, 3 for the third, and so on.
If this cannot be accomplished with the append query, is there a way that I
can run an update query to seed this field? All I have been able to do is
update it to the total count or to 1 for every record. Please help! Thanks.

 

[Guest]

Just set the field to "autonumber" and don't append to that particular field.
When rows are added, that field will auto-number for you.

So, for example, if you have a table that is

ID (auto number field)
Last name
First name

Then you just append to the table Last name and First name, and the ID field
will auto-populate....