I have a field call TimeIn (Long Time format). I'm trying to count the number of occurances per hour.

I created a report. In the summary of the report I placed the following code: =If [TimeIn] Between #08:00:00# And #08:59:59# Then Count [TimeIn]

The code is wrong but I'm not sure how it's wrong. Any help would be appreciated.