I am running a sql query against a access database and when I run it under localhost or from a access query it does not return any records However if I run the same query using something like table editor or run the same query with the same page on the server it returns a full recordset.

Here is the query if that might help:

SELECT * FROM Rings WHERE Date Like '" & mid(Date,1,Instr(Date, "/")-1) & "%" & mid(Date,InstrRev(Date, "/")+1) & "' and Display = True ORDER BY Date Desc, ID Desc

Any help is greatly appreciated.
Thanks
-Scott

Different dates?

-PatP

I am trying to select all records from the current month from the db. Basically a new uploads list for users that will select all records for the current month and year but as I said does not return anything when run locally.

When the query runs it looks something like this:

SELECT * FROM Rings WHERE Date Like '11%2004' and Display = True ORDER BY Date Desc, ID Desc