Hello,
I use Access 2016 on a windows 10 laptop.
I am creating an Access table to manage my personal accountancy and, in my invoice table, I would like to fill in the column invoice number with a serial number code that includes the letter "S", the current year (yy), the current month (mm) and then a serial number of 3 digits starting with 001.
So the code looks like Syymm### (S2202001, S2202002, S2202003...)
So far I managed the first part using the following code in the default value filed of the column Invoice Code of my Invoice table:
="S" & Format(Now(),"yymm")
But I cannot figure out how the code to add automatic serial number starting from 001 after yymm.
Any solution?
Thanks in advance for your help,
Cheers,
Emeline
I use Access 2016 on a windows 10 laptop.
I am creating an Access table to manage my personal accountancy and, in my invoice table, I would like to fill in the column invoice number with a serial number code that includes the letter "S", the current year (yy), the current month (mm) and then a serial number of 3 digits starting with 001.
So the code looks like Syymm### (S2202001, S2202002, S2202003...)
So far I managed the first part using the following code in the default value filed of the column Invoice Code of my Invoice table:
="S" & Format(Now(),"yymm")
But I cannot figure out how the code to add automatic serial number starting from 001 after yymm.
Any solution?
Thanks in advance for your help,
Cheers,
Emeline