extract desired data

[AN60]

I have a simple tbl for rainfall with a date field & amount of precipitation going back about 25 years up to present and beyond. I want to view the data by month and by year eg monthly averages and totals and yearly averages and totals. Does anyone have any suggestions how I should do this?

 

[namliam]

i would suggest using group by query's ....

 

[Dugantrain]

You'll need two queries, one's going to be for Month, the other for Year. For the Month, you want to use the Month() function and pass your Date Field into the Function:

Month([Your_Date_Field])

You want to get an average over the month, so what you're needing to do is count the number of recorded days within that month, sum the rainfall, and then divide the Sum by the Count. You can do all this within one query using a Subquery or you can write your first query to Group By Month, Sum Rainfall, Count Days and then base another query off of this query and simply pull down the Month field and define a second field as:

[Sum_Rainfall_Field]/[Count_Days_Field]

Ditto for your Year query except Group By using the Year() function.