My SQL statement sometimes returns some results and other times nothing.
There are records to display, but for some reason it's not finding them.
I get rs.EOF = true.
Code:
        strSQL = "SELECT * FROM tbl_Finances"
        strSQL = strSQL & " WHERE Finance_Date BETWEEN #" & dtDateOne & "# AND #" & dtDateTwo & "#"
debug.Print strsql
SELECT * FROM tbl_Finances WHERE Finance_Date BETWEEN #01/06/2007# AND #01/07/2007#
In my tset table, I should be returning 6 records.

The code that loads from the recordset ro the flexgrid works when all records are displayed, so i am guessing that that code is not the problem.