I am very efficient with Access but not so much with code. I need to create a numbering system where I can select the start number(what company want their customer to know their customer number 2?). I think it would be best to use an "IF" statement for the beginning number and from there on, find the highest number in another table and add 1. I want to select the number of digit. Autonumber will not work because i need it to be repeatable for multiple records. Quotes can have multiple services and specification but share the same quote number.
Help would be appreciated. Thank you!