a query to search time and date

  • Thread starter Thread starter Lost
  • Start date Start date
L

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.
 
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#
 
Thank You very Much

Worked Perfectly


KARL DEWEY said:
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


Lost said:
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.
Click to expand...
Click to expand...
 
Back
Top