Date/Time Criteria

[KWarzala]

I have a Date/Time field in a table that i cannot change. I am trying to query the table, and have parameters Between[Start Date]And[End Date] but since the time is included in the same field if i try and query Between [6/1/10]And[6/2/10] it isn't giving me the data for 6/2 since it is probably using 0:00:00 AM as the time.

Is there a way to create the parameter to be something like:
Between[Start Date]&"0:00:00 AM" AND [End Date]&"11:59:59 PM"

I've tried a bunch of different ways, and i can't get it to work



Thanks!

[KWarzala]

Nevermind, i went back and tried one more thing and it worked!

Between [Start Date?] And [End Date?]+" 11:59:59 PM"

[_SD_]

Hi!
Between #13.10.2009# & " " & TimeSerial(0;0;0) And #11.11.2009# & " " & TimeSerial(23;59;59)

[kimmer]

or
>=[start] And <[end]+1