Auto Number

  • Thread starter Thread starter MetalJacket
  • Start date Start date
M

MetalJacket

I'm creating a concatenated field to use as a id number for reference when
talking to other colleagues about the particular record. I Use an autonumber
field as a unique id. In the issues table, the autonumber format is set to
IS000000. For a Questions table it would be Q000000. I would like to use the
autonumber field as part of a concatenated field, which would consist of
several fields. The problem is the autonumber field only shows the
incremented# and not the IS000001.

In my formula, I use = ID & Name & IssueType
My expected results is IS000001CATBUS
Instead I get 1CATBUS
 
An autonumber field contains numbers -- only numbers -- and does not
contain, nor will it ever contain, letters.

I don't know what you've done to "set it" to have IS as the beginning part
of the field's value -- perhaps in the Format property?

I assume that ID is the autonumber field in your expression? If you want it
to have six digits, your expression needs to be this:

= Format(ID, "000000") & Name & IssueType

As for including the "IS" value, you'll need to contatentate that into the
string, too:

= "IS" & Format(ID, "000000") & Name & IssueType
 
Ken,
That worked beautifully. I've been scratching my head on that one for two
days.
 
Back
Top