Report in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report includes companies and the projects that each company has. A
company can have more or 1 project. I need to know how to summarize how many
companies are included in the report. I only one each company counted once
no matter how many projects they have.
 
Hi

Ensure that each company ID (or other named primary field is included in the
report - in cae there are companies with the same name)

Add an unbound text box to the report footer.

use this as the control source of the text box
=Count([companyID])

Change "companyID" to the real name of the field

To count how many projects each copany has - do the same in the detail
footer - not the form footer or you will count all the project in the report.

Hope this helps
 
Back
Top