Between statement in a query

[mot98]

Hi all,

I have setup a query on one of my tables, that gets the user to input a start date and an end date.

The query works fine if you use multiple dates Ex: "08/25/2003" to "08/27/2003", it returns values for the 25th and 26th, but not for the 27th.

My statement looks like this:

Between [Forms]![frmMachineAll]![StartDate] And [Forms]![frmMachineAll]![EndDate]


How can I get it to return all records for every day entered???

Thanks for any tips...

mot98

"I'd rather be dead and cool..then alive and uncool."
---Harley Davidson & The Marlboro Man

 

[mot98]

Just a quick update...

If I run the query using "08/25/2003" to "08/25/2003" I get no results coming back.

But if I run the query using "08/25/2003" to "08/26/2003" I get both the 25th and 26th records?

How can I get it to work if they just want to type in the one day?

Thanks....

mot98

"I'd rather be dead and cool..then alive and uncool."
---Harley Davidson & The Marlboro Man