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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time - Show records 1
Diference between hours when hours in diferent recordset 9
Help needed to create a query 0
MTBI (Mean Time Between Incident) Date Difference Different Record 2
Calculating Meal Period Violations in Access 2
Diference in hours between to hours 2
Time Frame Query 2
Calculating diff between date/ time only between certain hours 5

Back
Top