Report wizard, step four

Specify if and how you want the fields grouped in your report.

You can group by more than one field. For example, in a report on sales, you might sort on quarter first and then under each quarter, by salesperson.

To select fields for grouping,

1. Select fields you want to group for display or summary (aggregate) operations. Select individual fields to move to or from the Selected Field lists by double-clicking or using the arrow buttons. (Double-arrow buttons move all fields.)

• To rearrange the order of fields in the Selected Fields list, drag them up or down.

• Select a sort order for each field added to the Selected Fields list.

• When you are satisfied with the fields, their order in the Selected Fields list, and each field’s sort order, click Next.

Dialog box options

Available fields

The Available Fields list shows those fields on which you can group your report. (You cannot group on BLOB fields, such as graphic or memo fields.)

You don’t have to group your report on any field, if you don’t want to. In that case, rows will be displayed in the same order as the source table. Also, you can use a field for grouping without including that field’s information in the report.

Select the fields that you want to use and move them to the Selected Fields list by double-clicking or using the arrow buttons.

Selected fields

The list of fields you are selecting to appear in the report. To remove a field from the list, double-click it or use the arrow buttons.

Field sort direction

For each field, choose a sort direction. To do this, highlight the field, and then click a radio button:

Ascending 1, 2, 3... and a, b, c....and so on

Descending 3, 2, 1 and z, y, x... and so on

Arrows

Click the > arrow to add the selected field in the Available Fields list to the bottom of the list of fields in the Selected Fields list.. Click the >> arrow to move all the available fields to the Selected Fields list..

Click the < arrow to remove the selected field from the Selected Fields list to the bottom of the Available Fields list Click the << arrow to remove all the selected fields from the Selected Fields list to the bottom of the Available Fields list.