I'm setting up a new mdb, and I need to assign record numbers. I need to know how to format a number that will show something like RD02045,and the next new record to be RD02046
I found this from Lonnie Johnson in a thread,
Or you can set the default value of this field on your form using the DMax function and increment by 1 like so:
= DMax ("[YourFieldName]","YourTableName" + 1
Will this work
Can I set up a text field this way?
-Smack
I found this from Lonnie Johnson in a thread,
Or you can set the default value of this field on your form using the DMax function and increment by 1 like so:
= DMax ("[YourFieldName]","YourTableName" + 1
Will this work
Can I set up a text field this way?
-Smack