Hi
I am new to Access and have a basic understanding of SQL.
I have a query that returns a data set that I then want to apply an Average function to. I know the SQL statement to perform the Average function (it involves GROUP BY).
Basically I know how to do these two steps individually, but can someone give me some guidance on how to apply the second Average query to the dataset returned by the first query.
Here are the two queries if it helps.
First Query:
Code:
SELECT [Site Serial], [Previous Year], [Current Month], [Average Grouping]
FROM [Sites and Weekly Averages]
WHERE ([Previous Year] IS NOT NULL) AND ([Current Month] IS NOT NULL);
Second Query:
Code:
SELECT [Average Grouping], AVG ([Previous Month]), AVG ([Current Month])
FROM [Sites and Weekly Averages]
GROUP BY [Average Grouping];
Many thanks
James