query causing problem with dates (1 Viewer)

[dgoulston]

ok i have a query with 2 fields,

Endtime: AccountTime
Starttime

both date input from another query, if i run without any criteria it works and get some results:

Endtime Starttime
9/6/2005 6:24:09 AM 9/6/2005 6:23:53 AM
9/6/2005 6:24:16 AM 9/6/2005 6:21:20 AM
9/6/2005 6:24:34 AM 9/6/2005 6:24:22 AM
9/6/2005 6:26:06 AM 9/6/2005 6:25:51 AM
9/6/2005 6:26:15 AM 9/6/2005 6:25:00 AM

and i have some inputs on a form (type - genreal date) with the values:
startdate:
09/06/2005 00:00:01
enddate:
09/06/2005 23:59:59

and the condition is on starttime field:
Between [Forms]![Main]![startdate] And [Forms]![Main]![enddate]

but i get no results....????

any help?
thanks in advance.

Dal

 

[Murli]

Your logic is correct and works for me correctly. Attached is the sample Database for your reference.

I dont know why you are not getting the correct results from your query.

Let me know if you find anything.