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 excel 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? It doesn't seem to matter what text I put in the
"like clause" it always returns zero, even when I know there should be rows
returned.

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

Thanks.
--
Rone

If you are using ADO (rather than DAO) then the wildcard character you need
to use is not * but %, so:

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

It always helps if you paste the code though!

MH



"Rone" wrote in message
...
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 excel 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? It doesn't seem to matter what text I put in
the
"like clause" it always returns zero, even when I know there should be
rows
returned.

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

Thanks.
--
Rone

Thanks MH. You were exactly right. It works fine now. I'm using ADODB and
thought the syntax was supposed to be exactly the same as if I was in access.

Lesson learned.
--
Rone


"MH" wrote:

If you are using ADO (rather than DAO) then the wildcard character you need
to use is not * but %, so:

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

It always helps if you paste the code though!

MH



"Rone" wrote in message
...
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 excel 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? It doesn't seem to matter what text I put in
the
"like clause" it always returns zero, even when I know there should be
rows
returned.

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

Thanks.
--
Rone