Numbers
 

anyone got a code for adding number before the auto-number in access?

ex.

access
(auto number)
1

vb 6.

(add number) access auto number

Re: Numbers
 

If you do the Select Sum(AutoNumberField) shouldn't that solve the problem. I am not sure and have not tested.