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

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