Some query types won't show (Union queries, and Parameter queries) when
you connect with the default method in Word 2003, which is OLE DB.
Typically you have to revert to the old DDE method (check Word
Tools->Options->Confirm conversion at open, then go through the
connection process again, and select the DDE option in the extra Confirm
box that appears). If you are in a position to modify the database, you
may be able to get some queries to run by wrapping them in a another
query that simply does
SELECT * FROM thequerythatOLEDBdoesnotsee
The problem with parameter queries OLE DB is that OLE DB itself has no
mechanism to prompt for the parameters, and nor does Word - with DDE,
Access does it. To work around that, you have to use e.g. Word VBA to
set up the parameters (prompting if necessary) then either generate the
SQL text that the Query would issue, or use a special technique to run
the query from Word VBA. I've never tired it for real, and it wouldn't
surprise me if Microsoft hadn't blocked that particular option since I
last looked.
Peter Jamieson
http://tips.pjmsn.me.uk