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.

[June7]

Don't need the concatenation and quote marks.

Build in Design view then switch to SQL view to see the statement.

[ssanfu]

Using VBA in a form module, you would use something like

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

Notice the delimiters...

In a saved query, you can't refer to the control "ReportDate" like that. It must be the fully qualified path.

SELECT * FROM [Log Watch] WHERE [Log Watch].EndDate= Forms!Form1.ReportDate;

Change Form1 to your form name