Problem filter recipient Word 2003 vs Query in Access

[Joan]

I have an Access Data base and a Word mail merge document. I used the filter
recipient "Street Address not equal to blank" and "Graduate equal to FALSE."
The result was that I was missing several records which met that criteria.
If I filtered using just "Graduate equal to FALSE," I got correct results.
If I filtered using just the "Street Address," I got incorrect results. I
finally built an Access Query and used that as the data source and the merge
was fine.

Am I correct, that I should be able to filter in Word? Is there a problem
with my field name? Thanks for your thoughts.

 

[Peter Jamieson]

In theory you ought to be able to do it in Word but in practice Word suffers
from a number of deficiencies - sometimes it does not construct the query
correctly from your criteria, and sometimes the mechanism it uses to issue
the query does not work properly. There was a short discussion about another
similar case in here a month or two ago. Nasty, but true.

Peter Jamieson