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