Hello all,
I am trying to put together a data acquisition package that gets a series of raw data (13 individual data points) from a control system every 60 seconds. I have been asked to give my client a report that averages these values every 30 minutes to reduce the physical length of the report. My data collection times will vary as will the total number of hours of data I am going to process with each test.
I currently do this calculation in Excel, but would like to simplify my spreadsheet report and eliminate some of my many formulas. Does anyone know a relatively easy way to do this average calculation from within Access97?
Thanks in advance for any help you can provide.
I am trying to put together a data acquisition package that gets a series of raw data (13 individual data points) from a control system every 60 seconds. I have been asked to give my client a report that averages these values every 30 minutes to reduce the physical length of the report. My data collection times will vary as will the total number of hours of data I am going to process with each test.
I currently do this calculation in Excel, but would like to simplify my spreadsheet report and eliminate some of my many formulas. Does anyone know a relatively easy way to do this average calculation from within Access97?
Thanks in advance for any help you can provide.
