Tricky Inventory Number System
I'm working on a database in which the client would like to have quite a complicated numbering system (reference number for each record). So far, I've been able to achieve the numbering system by using the below -
Left (SURNAME;5) & DATE & "_" & Inventory Number
Inventory Number is just set to auto enter a serial number which is pulled into the calculation.
However.. the client would like the numbers to run in accordance with the date. To describe, what they would like - examples are as follows:
Does anyone have ideas on how this can be achieved? What I think I need is a calculation for the inventory number which understands what the date is and what the last number for say, 2014, was.