Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word with Access changing criteria
Hi there
I have a mail merge document linked to Access query with no problem. Occasionally I want to restrict the records returned so change the criteria in Word rather than modifying query. For example I restrict to records from a particular table (identifed in the query) AND where Surname is blank. This works fine until I close the criteria box at which point another criteria is set by Word saying OR surname is blank thus giving me records from all tables where surname is blank. Each time I close and go back in it adds OR Surname is blank again!! Now I can quite easily resolve this by editing the query but would like to know why it happens and if I can overcome in Word. Is it a bug or just another anomaly when linking to Access....thanks for any replies. Sheila |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word with Access changing criteria
Should have said this is Word/Access 2003
"Sheila D" wrote: Hi there I have a mail merge document linked to Access query with no problem. Occasionally I want to restrict the records returned so change the criteria in Word rather than modifying query. For example I restrict to records from a particular table (identifed in the query) AND where Surname is blank. This works fine until I close the criteria box at which point another criteria is set by Word saying OR surname is blank thus giving me records from all tables where surname is blank. Each time I close and go back in it adds OR Surname is blank again!! Now I can quite easily resolve this by editing the query but would like to know why it happens and if I can overcome in Word. Is it a bug or just another anomaly when linking to Access....thanks for any replies. Sheila |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
is word perfect compatible with office word? | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help |