Results 1 to 3 of 3
  1. #1
    Lynn Cohen is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    30

    Find first instance of duplicated items in a long list of duplicated items

    Our system for generating IT Help Tickets only allows canned reports. The reports do not return a list showing one record per Help Ticket. They return a list showing one record for each person assigned to a Help Ticket; and there may be 1, 2, 3, or some other number of persons assigned to a Help Ticket.

    I have loaded all 49,000+ Help tickets into Access 2013. Obviously, too many to manually scan for duplicates.

    I have fields called
    Ticket Number
    Assigned To
    Problem Description



    My objective is to create a query that returns one record per Help Ticket. I stress “query” – I’m an information analyst, not a programmer, and not at all comfortable writing code.

    What I’ve tried:

    • the FIRST function – returns just the lowest Ticket Number of the entire list
    • a Find Duplicates query – returns 11,737 instances of a Ticket Number being duplicated – still too many to manually scan


    Any help will be greatly appreciated!

    Lyn

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Try this --- you'll have to replace my field and table names with yours.

    Code:
    SELECT HelpTickets.TicketNumber
    , Min(HelpTickets.AssignedTo) AS MinOfAssignedTo
    , HelpTickets.ProblemDesc
    FROM HelpTickets
    GROUP BY HelpTickets.TicketNumber
    , HelpTickets.ProblemDesc;
    I am reading your post to mean that the ticket number and description are the same for each of the replicated copies. That is, only the Assigned TO is different.

  3. #3
    Lynn Cohen is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    30
    Thanks very much!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Partially Duplicated Info
    By QuantifyRisk in forum Access
    Replies: 25
    Last Post: 07-17-2014, 01:51 PM
  2. Blank duplicated values
    By uframos in forum Queries
    Replies: 3
    Last Post: 03-25-2013, 12:46 PM
  3. Results from query are duplicated
    By funkygoorilla in forum Queries
    Replies: 7
    Last Post: 10-30-2011, 05:50 PM
  4. Lines duplicated with Queries
    By mari_hitz in forum Queries
    Replies: 3
    Last Post: 10-17-2011, 06:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums