G Guest Sep 19, 2006 #1 Can someone find a way for MS Access to reset an autonumber to 1 every financial year or everry calander year?
Can someone find a way for MS Access to reset an autonumber to 1 every financial year or everry calander year?
J Jeff Boyce Sep 19, 2006 #2 The Access Autonumber data type is not controllable. It is intended to be used as a unique row identifier. If you are using it as a human-readable sequence number, you'll need to come up with some other way to do this. I'll suggest that you look into "custom autonumbers" at mvps.org, or via Google.com. Regards Jeff Boyce Microsoft Office/Access MVP
The Access Autonumber data type is not controllable. It is intended to be used as a unique row identifier. If you are using it as a human-readable sequence number, you'll need to come up with some other way to do this. I'll suggest that you look into "custom autonumbers" at mvps.org, or via Google.com. Regards Jeff Boyce Microsoft Office/Access MVP
