I have a report which is grouped ItemCode which shows different departments and the price they have charged for the items. Some Departments charge different prices for the same item and I need to identify those. In the example below I want to see the group ItemA but not the Group ItemB - does this make sense? I can query out and only show ItemA Dept2 & Dept 3 but i need to see all of Group Item A. Can anyone help? All data is in one table though I can make new tables to split out the data if that's the only way to get the report I need.
Item Department Price
A
Dept1 $12.00
Dept2 $14.00
Dept3 $12.00
---------------------------------------------------------------------
Item Department Price
B
Dept2 $5.00
Dept 3 $5.00