Generating automize Customize Numbering

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi all,
Could anybody help me?
I'm trying to create numbering that's automaticaly and customizing for books.
For example I would like to create 07/18/Doc/1203/1
whereas:
07 is year
18 is from cluster number extracting from the table
Doc is for the type of book
1203 is for the month and date it was received, and
1 is for autonumbering.
Thank you for your help

GBU
 
Daniel said:
Hi all,
Could anybody help me?
I'm trying to create numbering that's automaticaly and customizing
for books. For example I would like to create 07/18/Doc/1203/1
whereas:
07 is year
18 is from cluster number extracting from the table
Doc is for the type of book
1203 is for the month and date it was received, and
1 is for autonumbering.
Thank you for your help

GBU

Don't confuse storage with presentation. Put each "piece" of that into separate
fields and then concatenate them together when you display them on forms and
reports. With each part in separate fields you should see that automatically
assigning the values becomes a LOT easier.
 

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

Subtraction of date 3
Dlookup 7
Query Date criteria 5
Create custom autonumber field 5
Generating Customer ID 3
Automated transaction grouping and numbering 1
custom autonumber 2
Extracting Month and year 1

Back
Top