No records when access query contains Like

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert - 23 Dec 2003 13:28 GMT

Is it just me or... when I mail merge to an access query
with a criteria containing Like and a "*" [eg
Like "member*"], no records are returned.

In ccess the query returns data, but in word 2002, no
records are returned for the same query.

HELP!!

Robert

Reply to this Message

Cindy M -WordMVP- - 25 Dec 2003 11:05 GMT

Hi Robert,

> Is it just me or... when I mail merge to an access query
> with a criteria containing Like and a "*" [eg
> Like "member*"], no records are returned.
>
> In ccess the query returns data, but in word 2002, no
> records are returned for the same query.

This is a consequence of the new, default connection method
Word 2002 mail merge uses instead of the old DDE. OLE DB is
ANSI-92 instead of ANSI-89. For details of what this means
in relation to Access, look up ANSI-92 in the Access Help
files.

What it means for mail merge is that you'll need to use one
of the older technologies to connect to these queries.
You'll find more details about this in the Word 2002
section of my website's mail merge FAQ.

Cindy Meister

Signature

INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message