XPAC Reference Guide

Field type

Field type

Previous topic Next topic  

Field type

Previous topic Next topic  

The field type for a data field determines how data is accumulated up the hierarchical structure of the database, how totals are calculated on reports and how special forms of data are stored and displayed. For information on available field types, see:

Title
Min
Additive
Max
Average
Difference
Weight Average
Ratio
Note
Product
Classified
Sum
Date
No Aggregate
Record.

Note

For a given data field, the field types of Additive, Average and Weight Average can be set as a different field type for each level of your database.

Changing the field type

You can change the field type for a particular data field by double clicking the field type column for that data field. Alternatively, you can right-click that data field in the field type column. XPAC will display a menu and select the Field Type option.

Either way, XPAC will display the following window and you can select the appropriate field type:

Changing the Field Type