Word with Access changing criteria

S

Sheila D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to show details of dataset when one type of data is still blank 1
query to show where no data in a stated column 0
Filtering receipients automatically changing 2
Looping through records and creating ID field 5
accessing apostrophe record in ms access using ms word vba 7
Merging from Access with criteria inputting 3
Access 07 query and merg to Word 07 3
combobox uncorrect result 2

Top