I want to use the Autonumber function in my table in a specific format. The format is SP10000. And I want Access to automatically number each entry by one with each new entry eg. SP10001...SP10002...SP10003.
Please let me know how I can do this as when I use the autonumber function it only gives me simple numbers such as 1...2...3...4 etc.