How do I imput mask this number 040801-1?

[Guest]

Under data type in design view, I am trying to format the imput mask so that
a specific format is achieved. The format is:

Year/Month/Day/Sequencial Order Number up to 99:

Displayed as 040801-01

 

[Joseph Meehan]

Under data type in design view, I am trying to format the imput mask
so that a specific format is achieved. The format is:

Year/Month/Day/Sequencial Order Number up to 99:

Displayed as 040801-01

I am sure someone has what you want, but why not two fields one with a
date and one with the order number? You can join them for reports queries
and forms.

Are you sure you are only going to need two digits. Plans like this
with two digits are sure to need three before long. If you add the
capability, it will never need more than two.