Query with Date Variable

[robrich22]

I keep getting type mismatch error with a query



SELECT * FROM [Log Watch] WHERE [Log Watch].EndDate=" & ReportDate &";

I am building this query in sql view of the query builder and clicking run to view the results. Keeps telling me type mismatch.

[pbaldy]

If you're in the design or SQL view of a query, you can't use a VBA variable (you could refer to a public function). If you want this to run from a saved query, simplest is probably to have the date value input on a form and let the query get it from there.