How do you combine characters from one field and append an auto number to it in Microsoft access?
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)
CombFld = XField & trim(str(AutonumField))
must have trim or answer will have space between alpha and numeric parts