Problem with SQL "Like" clause in Excel

R

Rone

I'm having a bit of difficulty running a basic SQL query using excel. I'm
connected to a Microsoft Access.

Here is the SQL I am using:

SELECT count(*) FROM 3_REPORT WHERE CallType = 3 AND PartyIDName Like '*fax*';

If I run this SQL inside Access it will run just fine and return the count
of rows just like I want. However, when I put it into the VBA it returns "0"
as the row count, but I know there are 192 rows. Is there a problem with the
"Like" clause and the VBA?

I'm not sure where to go from here. Any help will be appreciated.

Thanks.
 
Top