Inserting an Access Query into Word - "LIKE" Failure

U

UJDY

Using Office 2003 Professional...
I found that WORD does not like Access SQL with the "LIKE" Operator.

I had created a table and then Queries to slice it up. When I use the LIKE
Operator in Access the results are fine. When I try to INSERT/DATABASE the
same query in a WORD document I do not get the same result. After a lot of
trial and error I finally rewrote the SQL to use the MID function and it
worked.

The LIKE Operator does not seem to transport to WORD...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modern equivalent of Autotext in Word? 0
Insert Index into a Table 1
Word 2003 won't exit 8
VBA word change keys 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Cross-reference Insert Default Change 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top