Word recipient list empty with Access query.

wackywoo105

Registered User.
Local time
Today, 14:42
Joined
Mar 14, 2014
Messages
203
I have a query in Access and a word document that opens up the query. Currently the query contains every record in the database. If I alter the query in Access to select a certain set of records (based on dates) when Word opens the recipient list is empty. Checking for errors it says there were no records or no data records matched query options.

How can I get Word to open and use the modified query?
 
I should have been quicker to search for an answer. It seem replacing "*" for "%" in the query solves the issue.

Mods please delete if you feel the need.
 
Does the query produce the correct records when you open it in access?
 
Does the query produce the correct records when you open it in access?

I build the query with SQL in VBA. Using wilcards "*" works fine in access but then word reports no data. Using "%" instead of "*" shows no records in access but when word loads the query all the records are there.

I have just created 2 versions of the query. One I can open in access and the other is the one word links to. Both work fine in their respective programs.
 

Users who are viewing this thread

Back
Top Bottom