Creating a Query for Monthly Averages for Daily Data

[cemvula]

Good Day all,

I have created a database with frequency values that are mostly monthly however their is one set of data entries that are daily. This is an issue because my preferred data format is monthly. I would like to create a query that can generate monthly averages from my data observations that are daily. Could someone please help me achieve this?

Thank you in advance for your help.

 

[Joe4]

Welcome to the Board!

You can create a calculated field in your query to extract the month/year in a text field.
Then, you can do an Aggregate Query to Group the records by this new calculated fields, and average your numeric fields.
See here: http://www.fontstuff.com/access/acctut04.htm

 

[cemvula]

Thank you for the help Joe.

I have been able to do this by creating a simple query however I have hit another wall. I would like to add this command to my existing form I created.

 

[Joe4]

Just base your Form off of the new Query you created.