[shirl[_6_]]

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




--
shirl

[Peter Jamieson]

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

[shirl[_7_]]

Hi

It is just a simple Access query with the critera Like A* to find all
the postcodes which begin with A.

Shirley

Peter Jamieson;3202208 Wrote:
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



-




--
shirl

[Peter Jamieson]

OK, there is unfortunately a problem with using wildcards in queries
being used by merge, because Access itself expects to use * for multiple
characters and ? for single charactes, but when Word 2002 or later gets
data from Access, it uses OLE DB which does not recognise * and ? but
wants to use % and _ instead.

The simplest thing to do in this case is probably to have two queries,
one with
Like 'A*'
for use within Access itself, and another with
Like 'A%'
for use by merge. Obviously, if you only have to present one of these to
students, life will probably be simpler...


Peter Jamieson

http://tips.pjmsn.me.uk

shirl wrote:
Hi

It is just a simple Access query with the critera Like A* to find all
the postcodes which begin with A.

Shirley

Peter Jamieson;3202208 Wrote:
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



-

[shirl[_8_]]

Peter

Thanks for the reply, a colleague has also found a similar response and
we will report it to the exam board, I suspect that whoever wrote the
exam paper did not test using a query for a mail merge.

Thanks for taking the time to reply
Shirl


Peter Jamieson;3203295 Wrote:
OK, there is unfortunately a problem with using wildcards in queries
being used by merge, because Access itself expects to use * for
multiple
characters and ? for single charactes, but when Word 2002 or later gets

data from Access, it uses OLE DB which does not recognise * and ? but
wants to use % and _ instead.

The simplest thing to do in this case is probably to have two queries,

one with
Like 'A*'
for use within Access itself, and another with
Like 'A%'
for use by merge. Obviously, if you only have to present one of these
to
students, life will probably be simpler...


Peter Jamieson

http://tips.pjmsn.me.uk

shirl wrote:-
Hi

It is just a simple Access query with the critera Like A* to find all
the postcodes which begin with A.

Shirley

Peter Jamieson;3202208 Wrote: -
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



--



-




--
shirl