How do i set the autonumber back to 1

[Ajay Garg]

I have created an access query and the number has gone from 1 to 20
while i was testing the application.How do i set the autonumber back
to 1?
Thanks
Ajay garg

[Allen Browne]

Compact the database after deleting the test data:
Tools | Database Utilities | Compact.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ajay Garg" <aj*****@hotmail.com> wrote in message
news:d9**************************@posting.google.c om...

I have created an access query and the number has gone from 1 to 20
while i was testing the application.How do i set the autonumber back
to 1?