By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,116 Members | 1,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,116 IT Pros & Developers. It's quick & easy.

Autonumber Restart

P: 22
Is there a way to Autonumber (ex 1, 2, 3 etc) but have it reset to start again at 1 on the change of two fields? Ill try to explain..

A, B, Sub 1
A, B, Sub 2
A, B, Sub 3

C, D, Sub 1
C, D, Sub 2
C, D, Sub 3
C, D, Sub 4

A, D, Sub 1
A, D, Sub 2
Etc....

Is this possible?
Oct 24 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,473
I'm pretty sure not.

Open to contradiction though.
Oct 24 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Essentially nothing can be done with autonumber. It is generated by Access and can't be manipulated. Whenever I want to set my own incrementing number I do it programmatically in VBA. However, what you want to do sounds very complicated and I would suggest that you look at your table structures again for a better approach.


If you want to give us some more specific information on your structures, what you are trying to do and why we will try to help you.
Oct 25 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.