Yes, it can be confusing.
Is your query a "parameter query" (where the user has to provide the
value of one or more fields), or does it contain wildcards (LIKE
'something*'), user-defined functions (written in Access VBA), financial
series functions, or the "replace" function?
If so, let us know which - perhaps a simpler query would demonstrate the
specific thing you want to demonstrate (not sure what that is exactly)
without so many problems.
Peter Jamieson
http://tips.pjmsn.me.uk
shirl wrote:
Hi
I am using Office 2007. I have a simple database which contains about
20 records. Have created a query to find people who live in a certain
area. This query is then required to be merged to a Word document. I
have tried doing this straight from access and I have also tried from
Word using the mailmerge wizard.
Which ever method I use I when I tell it to use the query the data in
the query is missing when in Word. I found another message in this
forum which is similar and suggests using a make "table query" will get
over the problem, however, this is for an exam for students and they
must use the query for the mailmerge.
I have also tried using the word advanced options "Confirm File Format
on Open", this does work but is very confusing for the students.
Hope someone can come up with a simple explanation.
Thanks
Shirley