Please Register to Remove these Ads

Hello everyone,

I have a personal project for my office where I need to analyze contacts from our customers, specially does who called us several times.

So, I've created a table with some fields (date, customer ID, contact ID, reason of the contact, concerned product) and filled it with ~285k rows that represents 1 month of customer contact.

As I have to analyze subcontractors, I'm only interested by the rows with a customer ID that repeats itself at least 2x in the whole column/field "customer ID" (in other words, I have to delete all "singles" contacts.

I've find many solutions to delete duplicate entries, but it goes in the opposite direction of my needs... somehow, I'd need a kind of filter on my table that would go like this : show only rows when the value in field Customer ID can be found at least 2x in the whole column/field Customer ID.

Does any of you have an idea how I should proceed to get this result ?

Create a Query of the table.

Click the "Totals" button, add the customer ID field 2 x

Under the second customer ID field change it from Group by to Sum

In the criteria field under the second Customer ID field enter >1

Hope this helps,

Dan

__________________
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the scales and adding to my reputation, Thanks!