Freefall69
Technical User
Running Access 2016 and importing a .csv file from server, which contains equipment usage information. The usage information is provided in 15-minute intervals (collection) each day by ID and channel as shown in example. The example shows ID’s pf ACME 01 and ACME 02 and associated channels (1-1-1, 1-1-2) with collection time and associated in and out usage for a two day sample. I am looking for help on methods to take 7 days of collected data and only report the max usage interval for each ID and channel. I have provided a sample of the collected data and desired report output based on export of data from Access query. I am uncertain if this can be reported in final query this way or will need to be separated into in usage and out usage on separate record lines. I believe the sample data and desired output as shown in the attached spreadsheet communicates what I am trying to accomplish but please let me know if additional info is needed.