Sequencial Identification Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having read through the Auto Number stuff I would like my identification
number to be sequential I would also like it to start with A or 015.

I don't know how to set the formula in a field to make this happen.

Please help.
 
BJ said:
Having read through the Auto Number stuff I would like my
identification number to be sequential I would also like it to start
with A or 015.

I don't know how to set the formula in a field to make this happen.

Please help.
Click to expand...

See:

http://www.lebans.com/rownumber.htm

As for the A or 015, I suggest that you don't make that a part of the
data stored. You can display the the data on a form or report, or even a
query with that as a prefix. No need to save it in each record like you
would do in a spreadsheet file.
 
Back
Top