First of all, you have to have an understanding at how Access manipulates Date and Time values. In a nutshell, the Date/Time datatype is actually a special Double number. This whole, or integral, number is determined by how many days have elapsed since December 30, 1899. The fraction determines the time that has elapsed since 12:00 midnight.
Therefore, for midnight on Oct 23, 2005, the days elapsed would be 38,648 since Dec 30, 1899. Therefore, 38648.0 = Oct 23, 2005 12:00 AM
Now, 12:00 pm, or noon, is exactly one half of one day, therefore it's no surprise that the number value for Oct 23, 2005 is 38648.5
Ok, now you want to get all the times between 8:00 AM and 10:00 AM, so we need to work on the fractional part of the double number. 8:00 AM is 8 hours after midnight, so the fraction part of the day is 0.333333333333333. Using the same calculation for 10:00 AM, we find the fraction part of the day is 0.416666666666667.
Therefore, since you have no date ranges, you just need to find records where the fraction part of the date/time group is >=0.333333333333333 and <=0.416666666666667.
Assuming your table is called tblEntry, using the following query will extract all entries that occur between 8:00 and 10:00 am of their particular day. Note the calculaton in the WHERE clause that uses the INT function.
SELECT Incident_Type, Time_Assigned
FROM tblEntry
WHERE ((Time_Assigned) - INT (Time_Assigned) >= 0.333333333333333
AND ((Time_Assigned) - INT (Time_Assigned) <= 0.416666666666667
Go ahead and paste this query into an SQL design box. Make sure you change the name of the table to that of your table name, and I'm assuming your fields are correct. Once you run the query, go back to the design grid, and you can create an aggregate query to group by your Incident_Type field.
