calculating number of incidents between certain hours

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am just teaching myself Access. I need to track patient falls between
certain hours of the day. When I type in >08:00 am and <07:00 pm in the
query boxes, all I get are all the records with no filtering. I have this
field set up as a DATE/TIME type.

Thank you
 
I did a query using exactly what said and made sure my field was date/time
and I got the correct results. I am confused on why it would work for me but
not for you.
 
If you only store the time component in this DateTime field, try the criteria:

BETWEEN #08:00# AND #19:00#

Literal DateTime values should be enclosed in hashes (#).

If you actually store date and time components in this Field and you only
want to select according to time, the create a Calculated Field / Column:

TimeOfFall: TimeValue([YourField])

and set the above criteria to this calculated Field.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top