I did a similar thing when building a form letter.
My customer table had the following fields:
FName, LName, Address, City, State, Zip
In query design view for the query on which my letter was based, I entered the following into the Field box:
Address: [tblCust]![FName] & " " &...