assign numbers

[shadowsedge]

Is it possible to assign alpha numeric numbers to a field, incrementally?


would like it to be RA16-0001 where "RA16-" doesn't change and the 0001 changes based upon the previous record that was successfully created.
This is not the unique ID of the record, just a 2nd field that would be created upon saving the record to the database.

Example:
1. A person open a form and fills in the blanks. (data entry)
2. The person clicks a save button and the information is updated to the database and "RA16-0001" is added based upon if there was a previous "RA16-0000".
3. The person then clicks print to make their own copy with the record ID and the Report ID on it. (if a hard copy is needed)

Basically, every time a new record is created, a report number is created/added above the previous one so that I can note if there were any missing reports that may have been deleted.

[pbaldy]

You can use the DMax() + 1 method. I'd keep the 2 parts in separate fields. That will make it easier when the first part that doesn't change...does change.

[shadowsedge]

What is the dmax +1 method?

[pbaldy]

Down near the bottom:

http://www.baldyweb.com/CustomAutonumber.htm