I want to sent up a database to track repairs. The current database is written using the rather archaic Lotus Approach 97, which nobody at work knows how to work anymore, so the job has fallen to me to create a new database.
The present system logs each repair with a unique number SP50000, SP50001 etc...
This seems like an ideal job for an autonumber field, but Access will only allow this to be a number, not 2 letters and a number.
If the first 2 initials are always the same eg SP in your example and there are always the same number of digits, you can set the field as Autonumber and then use the following in Format: "SP"0000. Let me know if this is suitable or if there is something I have missed.