Merging or combining Text based Fields

[compunow]

Hello,

I imported my mail list from a text delimited file into access 2000. This
has over 7,000 records. My problem is my zip code fields are separated into
two different fields ex: Field113 has 11501 and Field114 has 2232. I need to
merge these two text fields so the out come will be: 11501-2232 then I can
generate my barcodes in word mail merge.

If any one know how to.

pls help.
thanks

 

[Van T. Dinh]

It depends on whether you want to change the data in the Table or you simply
want to combine them for MailMerge. Either way, use the expression:

[Field113] & "-" & [Field114]

to combine them. For example, you can create a SELECT Query like:

SELECT [Field113] & "-" & [Field114] AS ZipCode
FROM YourTable

to show all the combined ZipCodes.

 

[John Vinson]

Hello,

I imported my mail list from a text delimited file into access 2000. This
has over 7,000 records. My problem is my zip code fields are separated into
two different fields ex: Field113 has 11501 and Field114 has 2232. I need to
merge these two text fields so the out come will be: 11501-2232 then I can
generate my barcodes in word mail merge.

If any one know how to.

Easy one. Create a Query based on your table and type into a vacant
Field cell:

Zipcode: [Field113] & ("-" + [Field114])

This will give 11501-2232 if the Zip+4 exists, and just 11501 if it
doesn't.

 

[John Spencer (MVP)]

Use a calculated field in a query.

FullZip: Field113 & IIF(IsNull(Field114),,"-" & Field114)

 

[John Nurick]

....and please don't post the same question separately to multiple
newsgroups. It wastes time and causes confusion because people reading
one group can't see that the question has already been answered in
another.