Problem filter recipient Word 2003 vs Query in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joan - 06 Oct 2006 19:16 GMT

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.

Reply to this Message

Peter Jamieson - 07 Oct 2006 01:21 GMT

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

>I have an Access Data base and a Word mail merge document. I used the
>filter
[quoted text clipped - 10 lines]
> Am I correct, that I should be able to filter in Word? Is there a problem
> with my field name? Thanks for your thoughts.

Reply to this Message