Equipment Utilization

[Gorio]

I need to generate a report that shows equipment utilization over a time period. Given a period of days and the times of interest how many times was all the equipment in use and for how long each occurrence.

I have a database in which I have tracked on what days a piece of equipment was used, when it started and when it finished. Now all I need is a way to show how many were busy at any one time.

As my supervisor would appreciate the ability to dynamically select the dates and time frame.

The only way I can even imagine of doing it at this time is with code. I have a vague idea of how to do it via brute force by populating a temporary table with the appropriate data. Then stepping through it minute by minute over the days chosen, create yet another temp table which I would query to create a report grouped by day and minute.

Does this even sound reasonable?

 

[charityg]

Brute force? No, I don't think that's necessary. Can you create a query that generates all information you need? Then perform the calculation and use a between [] and [] parameter criteria to select the appropriate time frame? Make this the datasource for the report and you would be set. It's a little hard to explain exactly what to do without knowing exactly what you are looking for. If you have any questions email me and I will try to help after getting a few more details.

 

[Gorio]

The email with some better descriptions of what I am trying to do is on it's way. Thanks for the assist, you are a real source of help here.