[Solved] How to Translate this statement in MS Access Query?

by


First of all get all the duplicate records by using group by and having clause 

select * from table where (Document_No,Distribution ) in (
select Document_No,Distribution  from table 
group by Document_No,Distribution having count(*) >1
)

or

select t1.Document_No,t1.Distribution from table t1 join 
(select Document_No,Distribution  from table 
group by Document_No,Distribution having count(*) >1
) as t2 on t1.Document_No=t2.Document_No and t1.Distribution=t2.Distribution

3

solved How to Translate this statement in MS Access Query?