So i need to have a query setup to just count the total number calls made but only count the total number as 1 unit (individual customer account)
Fields i have available within a table are
Account Number
Date of call
Time of call
Week Number
Notes
so looking for the query to show like a pivot
Account Number
Date of call
Time of call
Week number
Count of all calls to individual customer (so if 3 calls attempted in the same week just count as 1 call count)
Totally lost please can you help
Fields i have available within a table are
Account Number
Date of call
Time of call
Week Number
Notes
so looking for the query to show like a pivot
Account Number
Date of call
Time of call
Week number
Count of all calls to individual customer (so if 3 calls attempted in the same week just count as 1 call count)
Totally lost please can you help