Duplicate values with a condition (1 Viewer)

[Joy83]

Hi
I have a table
ID, Unit, Department
I need your help to extract the records (not the count ) but to filter those IDs that are duplicates but the department for them are not the same

1	Unit1	Dep1
1	Unit2	Dep1
3	Unit3	Dep3
2	Unit1	Dep1
5	Unit2	Dep3
2	Unit3	Dep2

I want a query that gets me the two records of ID (2) because they are duplicated and not sharing the same department

 

[Ranman256]

start the Query Wizard, click Find Duplicates,
it will ask for what field are duplicated: add UNIT, DEPT
then it will ask other fields, add ID
run