Cannot see queries from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lillian - 13 Nov 2003 06:38 GMT

I am trying to do a mail merge with data from Access 2002
in Word (Office XP), but some of the existing queries are
not showing. Actually, the database has just been
converted from Access 97. So is this a problem with
Access or Word, and how to fix it? Please help!

Reply to this Message

Jan Verstraeten - 13 Nov 2003 07:34 GMT

Hi,

I have the same problem. (just asked yesterday)
Check if in your query (queries) a calculation is done like " TEST:
Nz([xxx])-Nz([yyy]) " or "TEST: Nz([xxx])*y "
When I remove all this calculation fields my query is seen in the merge.

Ok ... this is not a solution, but ...
When you install Office2000 it will work.

If the thing is not working I need to reconfigure the whole database, and
this is not possible at the end of the year.

Greetings

Jan

> I am trying to do a mail merge with data from Access 2002
> in Word (Office XP), but some of the existing queries are
> not showing. Actually, the database has just been
> converted from Access 97. So is this a problem with
> Access or Word, and how to fix it? Please help!

Reply to this Message

Doug Robbins - Word MVP - 13 Nov 2003 07:44 GMT

Hi Lillian,

The problem maybe the situation discussed in the Knowlege Base article "No
Records Are Displayed When You Merge Data with Microsoft Word" at

http://support.microsoft.com/default.aspx?scid=kb;en-us;301595

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Reply to this Message