Report from a data logging table

[chrismec]

Hello all, I have a data logging table with the following columns: (DateTime) (EquipmentNumber) (StartStop) Each time a piece of equipment starts or stops it is logged into the table on a new record with the Date & Time, the equipment number (1,2 or 3) and a number one for a start or a zero for a stop. From this table I need to run a report and display the daily and monthly run times for each equipment. Narrowing by equipment to a specific time frame seems trivial enough however I am having a hard time coming up with a method for determining run times. Any help or guidance will be greatly appreciated. Below is a very small example of the data. Thanks so much!

[aytee111]

Probably need to write a VBA function to create a table in the format you need for the report.