Sequencial Identification Number

[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.

 

[Joseph Meehan]

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.

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.