Adding a letter after a date

[Sturgis76]

Hoping someone can give me some help. I have a form for purchase orders. The way the company has created work orders in the past is by date, a letter to show if it was the first, second, or third, order of the day and then some other numbers referring to the application of the item ordered. So the first order on 4/12/17 would be 041717A, second order would be 041717B. The part I'm trying to figure out is how to have the letter auto populate after the date. I'm not even sure if this is possible. I got the box to auto fill the date by using the Expression builder with =Format(Date(),"mmddyy") under the default value for the text box. Thanks for your help.

[CJ_London]

google 'dmax+1' which is the way you need to do it but your code does not fit the profile so you need to rethink

dmax will give you the largest number - but with your date format, 9/10/17 gives you 091017 - which is larger than 041217 - you need the numbers the other way yymmdd - which would give you 171009 and 171204

you are then appending a letter - so what happens after you've done 26 orders?