Reply to thread

Message: [QUOTE="Milly Staples [MVP - Outlook], post: 7109861"] 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: [URL]http://support.microsoft.com/KB/555375[/URL] 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? [/QUOTE]