I have an access problem regarding input mask and format.
I would want to have a serial number to be looking something like this :
"AMP-12-06" where "AMP" is an alphabet , "12" is a number and "06" is the year. How do I go about doing it?
I've tried a couple of format to be inserted in. Some of which are " AMP-"00"-"0\6" or "AMP-"00"- ( dateFormat="yy",[reference number]). None of them are successful. So yeah. Any help please? I need help urgently. Thank you.