Database Programming
Microsoft Access

How do you combine characters from one field and append an auto number to it in Microsoft access?

User Avatar
Wiki User
September 11, 2007 10:50PM

If Field is named XField and has value say "XXXX"

If Autonum Field is named AutoNumField value 123

If Combined Field is named CombFld

CombFld = XField & AutonumField (XXXX123)

OR

CombFld = XField & trim(str(AutonumField))

must have trim or answer will have space between alpha and numeric parts