MS Access 2007 SQL Statement (1 Viewer)

[Sigma248]

Can anyone tell me what is wrong with this SQL Satement when used in a MS Access 2007 CurrentDB.OpenRecordset command.

("SELECT tStatusChanged.AddressNumber, tStatusChanged.StatusNumber, tStatusChanged.StatusChangedDate" _
& " FROM tStatusChanged" _
& " WHERE tStatusChanged.StatusChangedDate <=#" & Format(tempDate, "mm/dd/yyyy") & "#" _
& " ORDER BY tStatusChanged.AddressNumber, tStatusChanged.StatusNumber")

Where tempDate is a Date type variable.

I am pretty sure its the <= that's incorrect but I am not sure what it should be.

Thanks.

 

[pbaldy]

Do you get an error? Unexpected results?

 

[Sigma248]

I get unexpected results. An empty recordset when I should get a recordset with some records.

 

[gemma-the-husky]

why dont you design your query as a stored query

then just

docmd.openrecordset "mystoredquery"


--------
its far easier to design a query visually, than write the SQL, and you can see the results you get.

 

[pbaldy]

Have you set a breakpoint to make sure the date variable contains what it should? <= should work fine.

 

[Sigma248]

Thanks everyone, got it working, the >= is correct.