The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.

Couple this with the concept of correlated-subqueries (the process of running a "child" query for each row in the "parent" resultset), and you can get pretty much anything you want with 'simple' SQL.