What if a three year comparison were needed? Would it look something like this where the left outer joins are at the same indent level?
Inner Join (current Year) cytbl

I thought this at first, too. But GPPG is text with mixed values of 04,05,06,C,B,D - different set for each company.

OK - I found the problem but not the fix. It isn't resetting parameter values when the "Company" parameter changes. If I run it for Company 1 with...

That’s the strange thing, there is no ‘B’ in Inventory Posting Group, only GPPG. If I run the Query without the Inventory Posting Group portion and select the ‘B’...

I'll get to work on that. I tried a Matrix, but that didn't work because the selected DateGroup column needs to show even if there is no data for...

Thank you, Not In worked. I was using Like because that is how the code was created on the SQL server when I created this as a new...

Thank you John, will give that a test soon as I get past problem two.