What is the relationship between clients and contacts? Is it this?
Clients::ClientID = Contacts::ClientID
Count ( Contacts::ClientID ) will count all related contacts records for a given client. A "count of" summary field defined in Contacts will produce the same count.
To limit the count to a specific date range can be done by including dates in the relationship or by using a filtered portal (If you have FileMaker 11 or 12.)
With a filtered portal, you can make it a one row portal and put the previously descrbed summary field in the portal row and it will corretly count the filtered, related records.
GlobalsTable::gDate1 < Contacts::Date AND GlobalsTable::gDate2 > Contacts::Date
is one possible portal filter.
Clients::ClientID = Contacts::ClientID AND
Clients::gDate1 < Contacts::Date AND
Clients::gDate2 > Contacts::Date
Would work as a relationship. (gDate1 and gDate2 should most likely be defined as global fields.)
Thank you so much! That cleared up my problem entirely!!!!