I have a table where i record a parameter 3 times a day, at the end of the month i need to run a report that averages each days parmenters.
I have a table where i record a parameter 3 times a day, at the end of the month i need to run a report that averages each days parmenters.
You'll need a Totals query, grouped on day, average function to provide the calculation per day.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Yes it 3 records.
I enter the dissolved oxygen in a table 3 times a day, at the end of the month I need to run a report that will show the average daily dissolved oxygen level for each day in the month.
Is your result to be 1 value/number? Or, 30/31 values, 1 for each day of the month?
The latter I would suspect?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
It seems either way Micron has provided the necessary info/answer.