Count records which have had a subform record added this week / month / year

Count records which have had a subform record added this week / month / year

Tried to post before but it never appeared in forums - just said waiting approval but I can't find anywhere!!

Anyway straight to the point..

I have 2 forms of interest (Company, Call_logs)

Call_logs is a subform within Company

I also have a page (Monthly_Report)

in this page, I want the following date to return the number of Companies that have been called this week / month / year

  1. Company A = 5 Call_logs
  2. Company B = 2 Call_logs
  3. Company C = 7 Call_logs
  4. Company D = 1 Call_logs

Ie 4 companies called this week

However my function/code tells me that 15 companies have been called
  1. WeekCallcount = Company[Call_logs.Time_of_call in this  week].count();
I have tried the following code also - but it doesn't give the numbers that I'd expect
  1. WeekCallcount = Company[(Modified_Time in this  week && Call_logs.Time_of_call in this  week)].count();
Any help would be much appreciated

Thanks

Rob