Quote Originally Posted by matthewspatrick
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...
How would I use LEFT JOIN or RIGHT JOIN instead? Is it just a case of replacing INNER with LEFT or RIGHT?

Is it? I'll have to stop doing that in future then!