Concatenate =Now() with dash and two digit number

[HeadGasket]

Tossing out my previous idea for generating a invoice number and thinking about joining =Now() with a "dash" and two digits. The two digits at the end would start at -01 for the first invoice number of the day and count up for each additional invoice number created throughout the day (-01, -02, -03, etc..). The following day, the dash number would reset back to -01 for the first invoice number of that day.



Like this for 1/10/2012..... and then 1/11/2012:

40918-01
40918-02
etc....

40919-01
40919-02
40919-03
etc....

Is this possible?

Thanks.

[June7]

It is possible. Requires VBA code.

Could just treat invoice numbering like check numbers. They start at some value and increment by 1 forever. Do you have to account for every number, no gaps in sequence?

Check out this recent thread on same topic https://www.accessforums.net/access/...ber-20506.html