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.

Hey, been reading the board for a bit. First post. I'm having issues coming up with a SQL query that will provide the average admits for each day of the week. The data structure looks like this: ...