Microsoft Office Tutorials and References
In Depth Information
CREATING QUERIES
FIGURE B-23
Count in a Totals query
Run the query. Your output should resemble that in Figure B-24.
FIGURE B-24
Output of Count in a Totals query
by splicing together the statistical
operation (Count), the word Of, and the name of the field (Employee ID). If you wanted a phrase such as
Count of Employees as a heading, you would go to Design view and change the query to resemble the one
shown in Figure B-25.
Notice that Access created a pseudo-heading,
CountOfEmployee ID,
FIGURE B-25
Heading change in a Totals query
When you run the query, the output should resemble that in Figure B-26.
FIGURE B-26
Output of heading change in a Totals query
You do not need to print or save the query output, so return to Design view and close the query.
 
Search JabSto ::




Custom Search