Generating automize Customize Numbering

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
 
R

Rick Brandt

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

Top