Unanswered: Reset the Autonumber field of Access back to 1
How can i reset the autonumber field back to 1?
i used the autonumber to assign unique order no for each ORDER. but, i need it to be set to 1 again the next day, so how can i do this thing. deleting all records doesnt make any sense coz it just increment from the last number although deleted.
i would appreciate any help you can give. thanks in advance.