Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problem with SQL "Like" clause in Excel
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. -- Rone |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Problem displaying recordsets in Excel Format | Excel Discussion (Misc queries) | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
Strange problem....excel not responding | Excel Discussion (Misc queries) | |||
Problem with Excel 2003 restricting functionality | Excel Discussion (Misc queries) |