Quote Originally Posted by icthus123
[...] I need all the tables present here, because I once I've got this part of the query right I'll be getting things from them too.

The query seems to work fine until I add [tblDFC/School] and tblInvoice. When I add them, however, the figures for "Amount Committed" and "Amount in Progress" become totally different. I wonder if someone could tell me where I'm going wrong?
Well, any time you do an INNER JOIN, you restrict the result set to rows where each entry in TableA has a corresponding entry in TableB. My guess is that [tblDFC/School] and tblInvoice do not have entries for everything you were expecting to see from the other tables.

One way to deal with that is by using outer joins (LEFT JOIN or RIGHT JOIN), but Jet SQL does not like seeing INNER JOIN and an outer join in the same SELECT, so you will probably have to either use subqueries or break it up into separate queries.

BTW, it's terrible practice to use saces or punctuation in table or field names...