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
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.