Dmax and its format

swee

Registered User.
Local time
Today, 01:14
Joined
Aug 11, 2004
Messages
66
I want to create fields that are in the form IC0000001, IC0000002, etc. I can do the increment in the numbers by using the dmax function but how do I add the alphabets before it? How can I start with 0000001 instead of 1? Any help would be greatly appreciated, thanks so much!

Swee
 

Users who are viewing this thread

Back
Top Bottom