Microsoft Office Tutorials and References
In Depth Information
3. Click the right side of the Format text box to display the list of formats, and then click
Fixed . This format specifies no commas or dollar signs, which are unnecessary for the cal-
culated field and would only clutter the worksheet.
4. Click the right side of the Decimal Places text box, and then click 2 .
5. Press the Tab key twice to move to the Caption property, and then type Weekly Bonus .
See Figure 3-36.
Property sheet settings to format the calculated field
Now that you have formatted the calculated field, you can run the query.
6. Close the Field Properties window, and then save and run the query. The calculated field
now displays the name “Weekly Bonus,” and the value for Ski & Stay now correctly appears
7. Close the query.
Elsa prepares a report on a regular basis that includes a summary of information about
the wages paid to student recruits. She lists the minimum hourly wage paid, the average
wage amount, and the maximum hourly wage paid. She asks you to create a query to
determine these statistics from data in the Position table.
Using Aggregate Functions
You can calculate statistical information, such as totals and averages, on the records selected
by a query. To do this, you use the Access aggregate functions. Aggregate functions perform
arithmetic operations on selected records in a database. Figure 3-37 lists the most fre-
quently used aggregate functions. Aggregate functions operate on the records that meet a
query’s selection criteria. You specify an aggregate function for a specific field, and the
appropriate operation applies to that field’s values for the selected records.