I plan on creating a table in Microsoft Access for capturing service ticket information. I plan on using the Auto Number ID field created by Access for a field I plan on naming Ticket Number. I would like the field for Ticket Number to look like TickNbrXXXXXXX. Where the XXXXXXX portion of the field would be equal to the AutoID number assigned by Access with preceding zeros. For example the first record would look like TickNbr0000001. This would limit my largest Ticket Numbers to TickNbr9999999. What kind of expression could I use to do this and do you think it is a good idea to use the Auto Number ID field in this fashion.
If this is not a good idea do you have any auto numbering suggestions for incrementing this field by one after each new ticket record is created with preceding zeros.