Appending a letter in front of autonumber?

shez

Registered User.
Local time
Today, 14:45
Joined
Jan 27, 2009
Messages
28
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?
 
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom