Problem w/ Date in SQL Statement

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

I am trying to view a list of reports that are more than 3 days old. Below is my SQL statement. When I open the page I see every report, not just ones that are more than 3 days old.

I am using MS Access as my database.

'Initialise the strSQL variable with an SQL statement to query the database DESCending order
strSQL = "SELECT * FROM orders WHERE CLOSED = false AND (Date_Entered >= #" & DateAdd ("d", 

-3, Date) & "#) AND IssueType LIKE 'Return' OR IssueType LIKE 'Product Discrepancy' ORDER BY 

orders.Date, orders.IssueType, orders.Receiver, orders.ID;"