Microsoft Office Tutorials and References
In Depth Information
Manipulating the Data in a Report
so you can
You can count values only of fields that contain numbers; you cannot count
values of a field that contains text, such as names.
To count the number of records or values in a report, follow these steps:
1. Switch to the Layout view of your report by following the steps in the
preceding section, “Switching a report to Layout view.”
2. Right-click in the column (field) that you want to count.
Access highlights your chosen column and displays a pop-up menu, as
shown in Figure 18-7.
3. Click Total.
The menu command displays the Total command along with the field
name you right-clicked, such as Total Last Name or Total Sales.
Access displays a submenu that displays Count Records or Count
4. Choose either Count Records or Count Values.
Access displays the total count in your report.
If you choose the Count Records or Count Values command again, you can
hide the total count in your report.