Count the occurances of a time during a date range

[acepayne]

Hello,

I would like to be able to count the number of occurances of a particular time during a specified date/time range.

For example:

Start: September 1, 2001 7:00 AM
End: September 3, 2001 9:00 AM

8:00 AM occurs 3 times during this range. Is there a way to have Access provide me with this result?

Any help would be awesome!
Thanks,
Gord

 

[Travis]

On a report set up a Group by on your Date/Time Field. Set a Footer for the group with the following.

Add an Unbound text box
Make its control source: =Count([Date/TimeFieldName])