View Single Post
  #4   Report Post  
Mike
 
Posts: n/a
Default

Winston,

What SP of Office XP do you have? I tried this same thing (Office XP Sp3
here) and it worked okay (eg, displayed the results of the query). One
thought - in Access, right click at the top of the query design (the field
list), click properties, see if "Output all fields" is set to yes. I don't
think this would matter - it's just a guess.

I'm also not certain why you say the option's not available in OLE - how are
you linking Access with Word?

Mike

"Winston" wrote in message
...
WinXPPro. Office 2002 Pro. Have been using Mail Merge using Jet 4 OLE DB
Provider and it has worked fine. Need to change so that the Mail Merge

uses
a query in Access as its data source rather than a table. This option is

not
available in OLE etc. So I changed data source to OCBC DSN and I can see

the
queries. But... it doesn't execute the Access query... just returns the

full
table (not using the criteria logic of the query). I changed the query so

it
uses a 2nd linked table rather than a criteria... still get all the

records
in the main table of the query. Can anyone help?
thank you,
Winston