Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problems Filter recipients in Word merge vs building Query in Acce
IMHO, Access is far superior at data manipulation than Word and I would use
a query in Access any time rather than try and do something like that in Word. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Joan" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
After merge I need to see the letters under the prompt box to edit | Mailmerge |