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 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 the records are grouped:
Click Next. For the next step, refer to Adding filters to your query.