Sums change when I add Inner Joins

[matthewspatrick]

Okay I think I've sorted that. Now it's telling me to create a query to include in my query to do that. How do I include a query within a query?

Create and save your first query. Now you can refer to that query as if it were a table.