Dupalicate Query can show other field too

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

I follow the wizzrad in making duplicate query, but it can only take me to
the fields that are duplicates. How if I want to show also other field in
this report, say Gender, status.

This is my duplicate query:
SELECT First(bukuangkby.FNAME) AS [FNAME Field], First(bukuangkby.LNAME) AS
[LNAME Field], First(bukuangkby.MNAME) AS [MNAME Field],
First(bukuangkby.NICKNAME) AS [NICKNAME Field], Count(bukuangkby.FNAME) AS
NumberOfDups
FROM bukuangkby
GROUP BY bukuangkby.FNAME, bukuangkby.LNAME, bukuangkby.MNAME,
bukuangkby.NICKNAME
HAVING (((Count(bukuangkby.FNAME))>1) AND ((Count(bukuangkby.NICKNAME))>1));


Thanks very much in advance
 
Try this additional query --
SELECT bukuangkby.*
FROM bukuangkby INNER JOIN [YourDuplicateQuery] ON (bukuangkby.FNAME =
[FNAME Field]) AND (bukuangkby.LNAME = [LNAME Field]) AND (bukuangkby.MNAME =
[MNAME Field]) AND
(bukuangkby.NICKNAME = [NICKNAME Field]);

Put the name of your duplicate query for [YourDuplicateQuery].
 
Back
Top