Counting values by date

[amy_creatza]

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 interaction is in less than 7 day from the previous interaction and not with the same agent in less than 2 hours?

[June7]

Won't be easy. For a record to pull value from another record of same table requires subquery or domain aggregate function. Review: http://allenbrowne.com/subquery-01.html#AnotherRecord

Your additional agent and time limit criteria are more complications.

[orange]

cross posted at http://www.utteraccess.com/forum/ind...wtopic=2030168