In MS Access how could I determine the days between the phone numbers in column A of the attached worksheet?
In the attached document I have phone numbers in column A and dates in column C.
There are two tabs in the example. The second tab is the result I am seeking.
How can I get MS Access to check the phone number against the dates in column B of the example result and provide the number of days since the phone number last called? Example_Days_Between_Sessions.xlsx