How? 2 gen a 4 digit # preceded by month and yerar?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shell - 01 Apr 2008 21:00 GMT

I would like to generate a PO number using the following

month/day/#### so it appears as, using todays date for example:
0508-0001

Is this possible for a Form?

Thank you in advance.
S

Reply to this Message

Klatuu - 01 Apr 2008 21:20 GMT

The first part is easy
Format(Date,"mmdd")
How do you want to determine the rest?
What will you do next year when the numbers start recurring?

Signature

Dave Hargis, Microsoft Access MVP

> I would like to generate a PO number using the following
>
[quoted text clipped - 5 lines]
> Thank you in advance.
> S

Reply to this Message

Shell - 01 Apr 2008 21:51 GMT

Hi Dave, and thanks for ther reply

Glad you asked - I expected that the new year would start the new number and
the 0000 would roll over after 9999. The numbers for date ned to be 2 digits
each. that is, Month ## and year ## (last 2 for year of course) followed by
the 4 digit.

Many thanks for your help.

> The first part is easy
> Format(Date,"mmdd")
[quoted text clipped - 10 lines]
> > Thank you in advance.
> > S

Reply to this Message