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
-