Moving fields
To change a field's position, proceed as follows:
Insert mode is the standard Query Painter setting, this means that whenever you position a field between to others, the system automatically makes room for the new field (without overwriting any existing fields). Overwrite mode can be switched on at will (Edit ® Overwrite). Fields overlap in overwrite mode and a corresponding warning is displayed in the window at lower right. Use the Order fields left-justified command in the context menu (right mouse button) to display all overlapping fields so that you can see them.
If you want to move a field within a line, select the field and enter a number in the field Output position in the lower left window. The line will be displayed at this position. Use the ruler to help you position your fields.
Changing the Output Length of a Field
To change a field's output length, proceed as follows:
You may also enter a value in the appropriate field in the lower left window on your screen to determine the output length of a field.
Increasing the output length may be particularly important if you are totaling a field and the output length required by the total is greater than that of the individual fields themselves.