Merging a field created by the LIKE operator into Word

D

Deb

In an Access query, I create a field which used the LIKE criteria. The query
returned accurate results. However, when I merged this field into a word
document, it did not merge in the correct values.

Here are the details:

I created the following field in an Access Query:
Company Contact: IIf([Organization] Like "HSBC*" Or [Organization] Like
"Citi*","company coordinator","representative")

The query results were just as expected with all HSBC and Citi records
containing "company coordinator" and all other records containing
"representative" in the Company Contact field. When I merged the Company
Contact field into a word document, every record showed "representative" and
no records showed "company cooredinator". If I exported the query to Excel,
the field merged properly. Does anyone know of a solution to this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging a field created from "LIKE" operator returns inaccurate va 1
How to display the merge function "url" of a picture? 0
Auto Fill Word Documents 4
ASK Field Formatting 1
Merge Excel file into Word Document 3
QBF & Query Malfunction 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to break up a book's endnotes by chapter in a file containing a whole book? 0

Top