Rank Your Sales Staff


Rank Your Sales Staff

Now that you know how much each employee has sold, you can rank your sales force. To sort employees by the amount of orders for September, click in the Sort cell of the Amount field. Then select the order in which you want the information sorted. You can rank employees by sorting the grand totals in descending order.

Want to sort by more than one field? Microsoft Access sorts fields from left to right. In the query design grid, arrange the fields in the order in which you want the sorts performed, and then click the sort order for each field.

Want to use the same query again? Save the query so you can reuse it. Click Save (File menu).

New Object button

Create a report from a query In datasheet view, click the New Object arrow, and then click New Report to create a report based on the query.

Office Assistant button

Want to know more? Look up Getting Results - Evaluate Sales in Help.

Next Steps

	To	See
	Learn more about sorting records	Use Your First Microsoft Access Database
	Create a query by using the Simple Query Wizard	Create a Sales Summary

Getting Around | Contents | Index

<< Previous Topic | < Previous Page | Next Page > | Next Topic >>