Step 2, in which you select which fields appear in the report, is shown below:
The options in this step are:
Table: a drop-down list that displays the names of the tables you can select fields from.
Available fields: a list containing all reportable fields from the table shown in the Table list that have not already been selected.
Selected fields for this report: a list showing the fields to be included in the report, with the table the field is from shown in parentheses.
Add: selecting this button adds the selected field in the Available list to the Selected list. You can also add the field by double-clicking it in the Available list or selecting it and pressing Enter. The field is removed from the Available list. Note: if you select a field from a table that is not related in any way to the other tables involved in the report, a warning message is displayed.
Add all: selecting this button adds all fields from the selected table to the Selected list.
Remove: selecting this button removes the selected field from the Selected list. The field is added to the Available list (although you may not see it if the table the field is from is not the selected table).
Remove all: selecting this button removes all fields from the Selected list, and adds them to the Available list (although you only see those fields from the selected table).
Values: displays a list of the unique values in the field selected in the Available list. This is handy if you're not sure what data a field contains.
