Checkbox to equal value in lookup field

[NewCMISGrad]

Example:
Room Complaints Checkbox
Comments Memo
Food Complaints Checkbox
Comments Memo
Nursing Complaint Checkbox
Comments Memo
General Complaints Checkbox
Complaint Dept Lookup box
Comments Memo

I want to run a report that will count: all room complaints and assign that number to Environmental Services, all food complaints and assign that number to dietary, all Nursing complaints to nursing and then all general complaints to the dept specified in the lookup box, for a report. How can I do this?


Thank You so Much,
NewCMISGRad

 

[Trendsetter]

Set up a report that has a Header/Footer for Complaint (The omega sign - Sorting & Grouping)
In the detail section put the memo

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[NewCMISGrad]

Thanks

Thank You so Much,
NewCMISGRad