Merging Table Data From Two Columns Into One

[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.

 

[George Nicholson]

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])

 

[Beetle]

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;