Serial Number

[osasaosasao]

Hello,
access 2010.

I would like to enter the serial number following criteria:
year (21) month (xx) 0000 (progressive).

It must automatically generate it in the order form.

Thanks so much

[isladogs]

The easiest way is just to use an auto number field 1, 2, 3 etc and then format the form control to add the rest of the information for display purposes only.

[NeoPa]

You may find the Item Numbering Within a Group article helpful with that. We may be able to give more specific help if you still need it and reply with what you've managed so far and where you're stuck - but not without of course.