Microsoft Office Tutorials and References
In Depth Information
CREATING QUERIES
FIGURE B-21
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.
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.
 
Search JabSto ::




Custom Search