WeekCallcount = Company[Call_Logs.Time_of_call in this week].count();
MonthCallcount = Company[Call_Logs.Time_of_call in this month].count();
YearCallcount = Company[Call_Logs.Time_of_call in this year].count();
Company = my form with Company records and subforms for contacts / Call_logs
Call_logs = subform within Company, used everytime customer is contacted
The functions above list total amount of calls in the time periods, however I want to add another set of functions which contains only the number of companies with records in those time periods
ie
5 companies called 7 times each this week equals...
WeekCallcount = 35;
WeekUniqueCompanyCallcount = 5;
I can't seem to work out how to separate it in this way,
Any help would be greatly appreciated,
TIA
Rob