Hi all,
I have continuing relationship One to Many between 3 tables that relation fields are [ServiceName], [UnitName] and [StaffName].
I would like to know in one Service how many unit and how many staff?
Please could you tell me! there are exist some ways or some formulas that can be use in query to count in field [UnitName] and [StaffName], The result will be number of Unit and number of Staff? (in different in values not the same like in attach file).
Thanks toward hope some one help me.
Please look attach file.
I have continuing relationship One to Many between 3 tables that relation fields are [ServiceName], [UnitName] and [StaffName].
I would like to know in one Service how many unit and how many staff?
Please could you tell me! there are exist some ways or some formulas that can be use in query to count in field [UnitName] and [StaffName], The result will be number of Unit and number of Staff? (in different in values not the same like in attach file).
Thanks toward hope some one help me.
Please look attach file.