How to I make my Autonumber field always begin with 1?

[Amy Badgett]

I have figured out that there is no easy way to create an autonumber field in a query, but that there is a way (supposedly) to create an autonumber field in a table or rather, there is already an autonumber field (the ID field). Is there any way I can make this ID or autonumber field to always begin with 1 so that it acts as a sort of counter/sequential numbering field for the records I put into the table?

I am appending the records from a query of fields from another table in case that has anything to do with it.

[TheSmileyCoder]

Autonumber fields reset to 1 when compacting (If table is empty)

Another option is to use code to delete the table, and then recreate it (using code)

[Amy Badgett]

To delete the table and recreate it using code would I do that in VBA?

[TheSmileyCoder]

Yes, I would normally do it in VBA. Im sure it could be done in SQL aswell, if one is more familiar with SQL.

[Amy Badgett]

I figured it out, thanks! ............... .