Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Autonumber - how to customize

Status
Not open for further replies.

marie515

Technical User
Feb 27, 2004
71
US
Hi all,

I'm interested in creating a field that will automatically generate a new log number into a record, but I don't just want a number, I would like to show the following (see example following):

RFP092004a

The break down of the above is:
*All records begin with RFP [RFP]
*All records are date stamped with month/year [092004]
*All records are incremented, e.g. [a], or , [c] etc.

Is this possible? Any suggestions?

Thank you.


 
search the FAQ areas in the following fora for details on how to accomplish this:

Forum701
Forum700
Forum181



Leslie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top