Microsoft Office Tutorials and References
In Depth Information
Totals query setup
Note that the Total cell contains the words Group By. Until you specify a statistical operation, Access
assumes that a field will be used for grouping (stratifying) data.
To count the number of employee IDs, click next to Group By to display an arrow. Click the arrow to
reveal a drop-down menu, as shown in Figure B-22.
Choices for statistical operation in a Totals query
Select the Count operator. (You might need to scroll down the menu to see the operator you want.) Your
screen should resemble the one shown in Figure B-23.