Merging Table Data From Two Columns Into One

  • Thread starter Thread starter Jack Stone
  • Start date Start date
J

Jack Stone

In the same Access 2003 table, I would like to merge 5-digit and +4 zipcode
data, now in two columns, into one Zip+4 column. The data will then be used
in a Word mail merge, since I cannot determine how to merge data in two
columns into the Word barcode field. Thanks.
 
Rather than physically combining the columns, why not just combine them into
one field in a query and use the query for your mail merge?

FullZip: iif(IsNull([ZipPlus4]), [Zip5], [Zip5] & "-" & [ZipPlus4])
 
The data should remain in two separate columns in your table. Create
a query that concantenates the two values into one query field, then
output the query results to Word.

Something like;

SELECT tblCustomers.CompanyName, tblCustomers.Address, [ZipCode] & "-" &
[ZipCodeExt] AS [Complete Zip]
FROM tblCustomers;
 
Back
Top