Appending a letter in front of autonumber?

[shez]

How would I go and do this? I have 1 solution but wanted some hints/check if I am on right path

To have two fields: Id, RefId... Id will be autonumber, in the form using macro/VBA (or even manually) I could copy ID value into RefId appending a letter in front?

 

[dkinley]

If in a query, just use something like ... NewNumber: [Letter] & [Autonumber] in a new column of the QBE.

If on a report or a form, you could use something like ... = Me.txtControlOfLetter & Me.txtControlOfAutonumber in an unbound control.

Note that you cannot edit any of these -it's for presentation purposes only (a calculated field). If this is something you want permanently then you will need to run an update query or bound the control so a field is populated with the data.

-dK

 

[Pat Hartman]

Letters cannot be stored in numeric fields. If the letter can change, it needs to be stored as a separate column. If the letter is always the same, you can concatenate it as dkinley suggested.