Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2006

Tip: Looking for answers? Try searching our database.

Word with Access changing criteria

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sheila D - 04 Jan 2006 16:22 GMT
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
Sheila D - 04 Jan 2006 16:40 GMT
Should have said this is Word/Access 2003

> Hi there
>
[quoted text clipped - 13 lines]
>
> Sheila
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.