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)
OR
CombFld = XField & trim(str(AutonumField))
must have trim or answer will have space between alpha and numeric parts

Improve Answer Discuss the question "How do you combine characters from one field and append an auto number to it in microsoft access?" Watch Question

First answer by Donaldmaloney. Last edit by Donaldmaloney. Contributor trust: 23 [recommend contributor]. Question popularity: 13 [recommend question]

Research your answer:

Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > How do you combine characters from one field and append an auto number to it in microsoft access?

Our contributors said this page should be displayed for the questions below. (Where do these come from)
If any of these are not a genuine rephrasing of the question, please help out and edit these alternates.
How do you combine multi access databases?