Hi - I am not very computer savy so any help would be greatly appreciated.
I am looking at doing a database to track development approval applications (I am a town planner).
From what I can see Access does an auto number function i.e 1 for first record, then 2 and so on.
I would like to work out how to program Access so it will auto number but using our format for applications.
i.e:
1st record: P20-001
2nd record: P20-002
3rd record: P20-003
(20 referencing the year and then obviously an application number. Could it be programmed so it will tick over to 21 next year and so on?).
Thank you so much in advance for any help!
Cheers
Hugo