How do I create a report that shows duplicate records?

D

DenaK

I am building a database based on people's calls to my organization. I need
to be able to see how many times we have received a call from an address as
well as what they called about. I made a duplicates query that shows me how
many times an address is in the database but then I lose all of the other
data about the call. Is there something that I can place in a basic query
that will give me all the data from duplicate addresses?

Thank you.
 
K

KARL DEWEY

Two ways to do it. You can use a subquery to pull the count or DCount. The
other is to use a totals query for count and then use that query joined with
the table to get the details.
AddressCount ---
SELECT ResidentList.Address2, Count(ResidentList.Address2) AS CountOfAddress2
FROM ResidentList
GROUP BY ResidentList.Address2;

SELECT ResidentList.Area, ResidentList.Address2, AddressCount.CountOfAddress2
FROM ResidentList INNER JOIN AddressCount ON ResidentList.Address2 =
AddressCount.Address2;
 
Top