in your recordset, change the join type from:
INNER JOIN
to:
LEFT JOIN
since you dont have matches in all of the tables being joined, you are not getting all the results you are expecting.
see this page for more details on the different join types and their uses:
http://en.wikipedia.org/wiki/Join_(SQL)