SQL Statement

[IanT]

Hi

I am using this code but the sql does not seem to work, can anyone help!

Dim strDate As String

strDate = Forms![frmComparison]![cboComparisonDate]

strSQl = "SELECT * FROM qryTest WHERE qryTest.ComparisonDate =" & strDate

 

[cityside]

Hi

I am using this code but the sql does not seem to work, can anyone help!

Dim strDate As String

strDate = Forms![frmComparison]![cboComparisonDate]

strSQl = "SELECT * FROM qryTest WHERE qryTest.ComparisonDate =" & strDate

Assuming cboComparisonDate returns a vsalid date, you need to add a # sysmbol before and after the date value.
Try :
strSQl = "SELECT * FROM qryTest WHERE qryTest.ComparisonDate =#" & strDate& "#"

 

[KenHigg]

IanT - When you have a problem like this you can use the immediate window to examine your variables and usually find out what going wrong...

Just a suggestion

 

[modest]

And you can also use the Locals window to watch your variables (data and data types of those variables) and objects.