Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mailmerge Query - Works in Access; fails in Word
Is there an issue with the LIKE statement in a query in Access when it's
applied to a mailmerge query from Word? I have a problem at a client location, and I'm not able to reproduce the issue on my own systems. XPPro, Word and Access 2003 is the environment, and within Access I have a query that includes a criteria LIKE "*G05*" against a field in the database. In Access, the query works correctly and returns 25 records from a database of almost 2000 records. On the same system, when I go into Word and specify the database/query in preparation for a mailmerge, there are no records selected or displayed. Using the same query back in Access, if I remove that criteria, the query now returns the full complement of records in the table, and then reloading the query in Word also now sees the query working correctly. Similarly, feeding a simple criteria against a different field (= "US") works under both applications, so it seems as if it comes back to some sort of issue, perhaps related to the LIKE statement, and how it translates through to the Word document and its query aghainst the database. Has anybody seen something like this before? Are there any workarounds that can be used? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The WordPerfect "Reveal Codes" method is so much easier to use. | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Wordperfect Office 2000 conversion to Word 2003 | New Users | |||
Boiletplates from Word Perfect | Microsoft Word Help |