Trying to create 6+ joins

[stephanie.ellis1]

I have a report where I am creating multiple joins.  By the time I get to the third level there is no longer any data at all pulling through.  Any thoughts on how to trouble shoot would be greatly appreciated.  Structure is like below:

Joined Dept data = Audit changes + OrgLvl2Info
Joined Job data = Audit Changes + Job Info
Joined Supervisor data = Audit Changes + Supervisor Info
Joined final Supervisor data = Query data + Joined supervisor data (created above)

Everything hold data until the last one and it is blank.  Thanks

[hespora]

Really the only help to give here without access to the data itself: Run tabular data. Right-click a query, select "view tabular data", and save the output. Do that with all queries, particularly with both queries running into a join and see if you could, for example, run an excel vlookup against the field(s) you're joining on. Something, somewhere, will be off in your queries.