Selecting fields
The Query Definitions window shows a list of available fields in the left pane. The right pane of the window displays a list of fields to be included in the query. Initially, this is empty.
Use the middle buttons to select the fields to be included in the query:
> moves the highlighted field from the left to the right hand side of the screen.
>> moves all the fields from the left side to the right side of the screen.
<< moves all the fields from the right side to the left side of the screen.
< moves the highlighted field from the right side back to the left.
Click HR Record button to include information from the HR record, such as Name and Address fields.
Clicking Totals when a field is highlighted on the right-hand side totals the value of this field if when the records are grouped.
Click Next. For the next step, refer to Adding filters to your query.