+ Reply to Thread
Results 1 to 2 of 2

How can i delete unique entries in a table

  1. #1
    Registered User
    Join Date
    02-26-2009
    Location
    India
    MS-Off Ver
    Access
    Posts
    46

    How can i delete unique entries in a table

    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 ?

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    270

    Re: How can i delete unique entries in a table

    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 "Star" and adding to my reputation, Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1