Helpdesk Analysis

[Bill]

Hi All,

Any suggestions on the best way to do this please?

I would like to do a retrospective analysis of helpdesk data to see how many
calls were open on the Wednesday of each week.

I think I am ok with getting the date of the Wednesday from the helpdesk
data (thanks for tie responses to a previous post).

The helpdesk data contains the opened and closed date for each call logged.

But I am not sure what is the best way to go about doing the analysis to
establish how many calls were open on each date.

There are many thousands of records and I do want to go back a year or so in
time to observe trends.

Any suggestions please?

Cheers.
Bill

 

[Jeff Boyce]

Bill

Consider a Totals query, grouping by date and counting records (i.e., record
IDs).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/