Microsoft Access: Using other fields in an Autonumber
3
votes
1
answer
369
views
I'm trying to use Microsoft Access to start an employee database. However, I want the display of the Employee ID to be the initials and then their number. For example, John Smith with the ID 0002 is JS0002. I've been playing around with format but it doesn't seem I can do this if I put my EmployeeID as an autonumber. Thanks in advance!
Asked by Sally
(31 rep)
Oct 14, 2020, 04:22 AM
Last activity: Mar 25, 2025, 08:07 AM
Last activity: Mar 25, 2025, 08:07 AM