>= or <= in a VBA SQL statement 1

[Zygor]

I'm creating a user input screen where the user can input a date range as a criteria of a report. The following is what I'm using. It partially works.

strCriteria = "[dtDateRun] <= #" & CDate(Me.txtDateToUse) & "#"

It gets all the records where it's less than, but not the equals to.


Any thoughts?

 

[rjoubert]

Try this...

strCriteria = "[dtDateRun] <= #" & CDate(Me.txtDateToUse) & " 23:59:59 PM#

 

[rjoubert]

Oops...sorry...try this...

strCriteria = "[dtDateRun] <= #" & CDate(Me.txtDateToUse) & " 11:59:59 PM#

 

[Zygor]

Eureka!

That was it. Thanks!

Have a star!

 

[PHV]

Another way:
strCriteria = "Int([dtDateRun])<=#" & CDate(Me!txtDateToUse) & "#"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886