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

  • Thread starter Thread starter Shell
  • Start date Start date
S

Shell

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
 
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up 2 combo boxes and then calculate another field 1
PING: Kaltuu - Dave 7
sum combo box based on other combo box 2
Calculate Chronological Age ex: 10 yrs, 4 mo, 2 days 2
start automatic number at a given value??? 4
Count Records for this week, this month, this quarter and this yea 2
Showing only records that are different from those preceding them. 1
Form Frustrations 6

Back
Top