Hi All,
I need to create a callback report. I have a call records table that has two columns: "Caller's phone number" and "Called phone number". Each record will either be a caller calling inbound or an agent calling the customer back.
I want to be able to match the phone number that an agent called out to the caller's phone number that originally called in. Any ideas on how to match two records where the phone number is in a different column?
Scaled down example:
Call Record From To Date
1 123-456-7890 agentx 2-3-2009
2 agentz 123-456-7890 2-6-2009
Need a report that shows that the From number was called back...
Thank you in advance.