SQLTeam.com | Weblogs | Forums

Access-filter data


#1

Hi,
I have a table(CustomerData) that stores interactions between agents and client and date of interaction. The fields are Agent-text, Phone-Number, Interaction Date-Date&time(like 1.1.2014 09:00 AM), Interaction Reason-text.
Any idea of how can I count the number of customers that interacted again with an agent only if the new interactions is in less than 7 day from the previous interaction and not with the same agent in less than 2 hours?


#2

Is this question about Microsoft Access?


#3

What have you tried this far?
Please provide table description (create statement), sample data and expedted output (from your provided sample data)


#4

Yes, Microsoft Access 2010.
I have a data base with that table and I need to count the customer who interacted again with an agent for each agent.I mean, if Agent Ben interact with a customer B(phone ) and then the same customer interact with the agent John in less than 7 days, then is 1 count for Ben.

Well I made a query selecting Find duplicates to find all the duplicate phone numbers (mainly this are the customers that interact again with an agent), agent name and interaction date. Now i need somehow to filter this by the interaction date.