Count where multiple fields are the same

[Rriemer]

Similar to an excel Countifs I have three fields that i want to see where all three are the same in different records - Account Number, Phone and Phone Type



I tried pulling all fields to view and clicked on Totals and then did group by for the three fields and then chose a random field for count. However the extra fields that i need for my output i do not want to group or count. I have tried multiple versions to no avail.

[Rriemer]

FYI I am trying to find duplicate records.. I think I will change try the wizard to find dupes?

[rpeare]

SELECT [Account Number], [phone], [phone type], count([Account Number]) as RecordCount FROM TableName GROUP BY [Account Number], [phone], [phone type]

use this as your 'base query' (qryPrelimStep)

Create a new query

Add your base query (qryPrelimStep) and your original table to the query, join on the account number, phone and phone type add the fields you want from either table.

[Rriemer]

I am not sure I am getting this right. I need to see all the records in the end. I want to export them with a few additional fields so I can remove the duplicates from my CRM

[Rriemer]

Yes now I understand. I created that table then created a second query and relating the original and the new table I have everything I need. Thanks.