Query From (and including) date - Thru (and including) date

[detrie]

Access 2000
Hi All.

I am running a select query on a date field.

I populate the table "date" field from a Microsoft Date and Time Picker Control 6.0(SP6).
I havent been able to figure out how to ONLY populate the date portion of the control so my field value containes Date & Time.

When I run the query, I have to select the day after my request to include the records I need. I think this is because of the time in the field
Example, If I want all records thru 6/17/2006 I must select "thru" 6/18/2006. This mucks things up if I have records dated 6/18/2006

Both of these statements give the same bad results:

Between [forms]![freports]![from] And [forms]![freports]![thru]

>=[forms]![freports]![from] And <=[forms]![freports]![thru]

Any ideas?
TIA
Detrie

 

[CraigDolphin]

Have you tried something like:
Between [forms]![freports]![from] And ([forms]![freports]![thru]+0.99999)