reset auto numbers

[Mrs.Meeker]

I've been doing testing in my database, and now that it's ready to go, I want to reset the auto numbers to 1. These are located on a couple of forms.

I have the following tables, tblNextSurveyNumber, tblSurveyNumber and a query, qryNextSurveyNumber. I didn't set these up myself, and I'm still learning!

thanks in advance
Rhonda

 

[dcx693]

To reset autonumbers, you need to delete all records from the tables, then compact the database.

 

[Mrs.Meeker]

LOL!!! I did that and didn't even realize that it had reset the numbers! Thanks buddy, for always being there for me!!! You're the best!

Rhonda

 

[dcx693]

You're welcome.