View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Joan Joan is offline
external usenet poster
 
Posts: 34
Default Problems Filter recipients in Word merge vs building Query in Acce

I have an Access Database. In my Word merge document I filtered the
recipients to "Street Address not equal to blank" and "Another field equal
to FALSE." I did not get all the records that met that criteria. I checked
several different things including deleting and rekeying certain records.
Interestingly, if I filtered on only the "Another field equal to FALSE," I
got the expected result. If I filtered on the "Street Address not equal to
blank" alone, I got unexpected results. Finally I built a Query in Access to
accomplish what I need and that works. My question is - is this an issue
with Word, or is there a problem with the field name, or should I continue to
look for some connection to the missing records? Thanks for your input.