I am trying to create a spreadsheet where I can track test scores for given
tests. I would like to automate, through VBA, the process of doing a query
for a test between two given dates and producing the overall average for that
test.

i.e. I may have given a specific test in the month of June 2009. This test
was given three times, in that month, to a group of 12, 9, and 5 individuals
respectively. I may give several different tests over the course of a year.
How can I query out a specific test and all the related scores for that test
between two given dates? Additionally, I need to calculate the average score
only for the results of the query.