[Nick O[_2_]]

Hi, I've worked with mail merge before but I'm stumped by a data source
issue. I connect to an Access 2003 database, and have no problem pulling in
data from one query (4,500 records), but when I switch to a second query that
has identical but with different criteria resulting in 16,000 records I get
nothing. Is there a record limit for merge that I need to think about?
Thanks!

[Peter Jamieson]

Do the "different criteria" include use of LIKE and wildcards? If so, the
problem is that by default Word uses OLE DB to get its data from Access, and
OLE DB expects to use ANSI SQL wildcards (_ and %) whereas Access expects
Jet SQL wildcards (? and *).

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Nick O" wrote in message
...
Hi, I've worked with mail merge before but I'm stumped by a data source
issue. I connect to an Access 2003 database, and have no problem pulling
in
data from one query (4,500 records), but when I switch to a second query
that
has identical but with different criteria resulting in 16,000 records I
get
nothing. Is there a record limit for merge that I need to think about?
Thanks!

[Nick O[_2_]]

I think you nailed it and I will take a look at this. Thanks!

"Peter Jamieson" wrote:

Do the "different criteria" include use of LIKE and wildcards? If so, the
problem is that by default Word uses OLE DB to get its data from Access, and
OLE DB expects to use ANSI SQL wildcards (_ and %) whereas Access expects
Jet SQL wildcards (? and *).

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Nick O" wrote in message
...
Hi, I've worked with mail merge before but I'm stumped by a data source
issue. I connect to an Access 2003 database, and have no problem pulling
in
data from one query (4,500 records), but when I switch to a second query
that
has identical but with different criteria resulting in 16,000 records I
get
nothing. Is there a record limit for merge that I need to think about?
Thanks!