Merging a field created from "LIKE" operator returns inaccurate va

[Deb]

In an Access query, I created 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?

 

[Milly Staples [MVP - Outlook]]

You may find that you will get a faster and more expert answer if you post to an Access specific group, rather than a general catch-all group like Office Miscellaneous.

Microsoft.public.access is probably a good place to start - the experts over there can redirect you to a specific news group if necessary but they should be able to get you started.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
How to ask a question: http://support.microsoft.com/KB/555375


After furious head scratching, Deb asked:

| In an Access query, I created 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?