a query to search time and date

[Lost]

I need to have a user defined query where the user will pick two date for a
search for between (date 1) and (date 2) but only put out information for
date with the time between 11:30am and 5:00pm.

The search is in a general date field named open time.

Thank You Very Much in advanced.

 

[KARL DEWEY]

In design view use two fields --
[open time] with criteria Between [Enter start date - m/d/yyyy] AND [Enter
end date - m/d/yyyy]
Calculated field --
TimeOfOpen: ([open time])-Int([open time])
with criteria on same row as for date --
Between #11:30 am# AND #5:00 pm#

 

[Lost]

Thank You very Much

Worked Perfectly

In design view use two fields --
[open time] with criteria Between [Enter start date - m/d/yyyy] AND [Enter
end date - m/d/yyyy]
Calculated field --
TimeOfOpen: ([open time])-Int([open time])
with criteria on same row as for date --
Between #11:30 am# AND #5:00 pm#

--
KARL DEWEY
Build a little - Test a little

I need to have a user defined query where the user will pick two date for a
search for between (date 1) and (date 2) but only put out information for
date with the time between 11:30am and 5:00pm.

The search is in a general date field named open time.

Thank You Very Much in advanced.