Why do mail merges in word ignore * wildcards in access queries

P

PaulB

I'm trying to mail merge from an Access 2003 query to a Word 2003 document.

The query has a * wildcard in the criteria string:
e.g. Like "*manager"
The query returns lots of results in Access

However, when I do the mail merge in word, it doesn't return any records.

Mail merges work fine for other filters and matches, just not those
involving the * wildcard. What's going on?
 
Top