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

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" <ajayz90@hotmail.com> wrote in message
news:d9477327.0405100609.6ba7466d@posting.google.c om...[color=blue]
> 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?[/color]