Query to calculate averages with criteria

I am new to using Queries in Access and need some guidance on how to simulate/convert code that I have written in Excel VBA to Access Queries.


I have a list of Course Codes (Columns A) and dates (Column B) in an Excel worksheet.
I run a select query on my access database to get the averages using this code in Excel VBA:
The result is the average grade by Course Code for the last 12 months

Please Login or Register  to view this content.

If I use this SQL code in an Access Query I get the averages on ALL values in my database.

Please Login or Register  to view this content.

My Excel VBA code allows me to reference each Course Code and corresponding date by values in a worksheet.

My research suggests that I am looking for something like Union ALL but my SQL coding is very limited so I haven't been able to solve my problem.

Any guidance on how I can adapt the Access Query code to simulate the Excel VBA code?

Why aren't you using the date part of the criteria in the Access query?

How do you want to group the dates?

Is the date criteria based on the current date?