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
If you do the Select Sum(AutoNumberField) shouldn't that solve the problem. I am not sure and have not tested.