Access 2007 Trying to get Report to break down Call Count within 3 consecutive time ranges.
-
I am new at this. I made a Access Database that produces a report that via an entered date range, displays data contained in the table when a user enters a Start Date and End Date to pull up the report. The report works fine; providing dates, time, caller names, locations, and a few other statistics. The Table has a field where the user notes the time a call is made(10:16). I need to enable the report to break down all calls in that field and count them in one of the three categories: (4:30 to 6:29), (6:30 to 8:29), and 8:30 to 10:30) I will look something like this on the report: (Where n is the total count of calls received within these three sequential time frames. Call Count 4:30 to 6:29 (n) Call Count 6:30 to 8:29 (n) Call Count 8:30 to 10:30 (n)
-
I am new at this. I made a Access Database that produces a report that via an entered date range, displays data contained in the table when a user enters a Start Date and End Date to pull up the report. The report works fine; providing dates, time, caller names, locations, and a few other statistics. The Table has a field where the user notes the time a call is made(10:16). I need to enable the report to break down all calls in that field and count them in one of the three categories: (4:30 to 6:29), (6:30 to 8:29), and 8:30 to 10:30) I will look something like this on the report: (Where n is the total count of calls received within these three sequential time frames. Call Count 4:30 to 6:29 (n) Call Count 6:30 to 8:29 (n) Call Count 8:30 to 10:30 (n)
Caveat I have not worked with Access for a decade or more :-O I would add a calculated field to the table/view called ShiftNo - function is obvious. Calculate the shift and then group the report by the ShiftNo. Your query changes from a simple select to a grouped query. (not sure what the terminology is these days in Access)
Never underestimate the power of human stupidity RAH