I have a table that contains customer ticket data and need to create a query to identify how often customers have a repeat ticket within 3 days. I am currently using Design Query with 2 instances of the the table and joining by customer ID.
Table Fields:
Report_TS
Customer_ID
Repair_Center
Repair_Type
Ticket_Num
Tech_ID
Example data
Report_TS Customer_ID Repair_Center Repair_Type Ticket_Num Tech_ID 1/1/16 1300 Bob123 Uptown GQ UGQ123 444 1/2/16 1000 Bob123 Uptown GQ UGQ130 455 1/2/16 1100 Cal333 Main ET MET132 333 1/3/16 0900 Bob123 Uptown GQ UGQ135 444 1/3/16 0930 Ann321 Downtown F1 DF1055 111 1/4/16 1100 Cal333 Main ET MET135 322
Expected Output
Month Repair_Center Ticket_Num Tech_ID RptTkt_Num Jan Uptown UGQ123 444 UGQ130 Jan Uptown UGQ130 455 UGQ135 Jan Uptown UGQ135 444 Jan Main MET132 333 MET135 Jan Main MET135 322 Jan Downtown DF1055 111
Any assistance on best way to proceed is greatly appreciated! I am getting duplicates