Hi everyone

I am creating a report which groups people based on the building they work in. What element would i need to put into the report and what expression would I need to apply to that element if I wanted to return the number of records in each building.

Any help with this would be greatly appreciated

I look forward to hearing from people

nreid82

you can count any of your fields -- I usually count the primary key field since it is always filled out. Create a calculated control in the building group header or footer

Name --> CountRecordsBuilding
ControlSource --> =Count([controlname_in_detail])