
Counts attached elements: Returns the number of polygons associated with the current record in the table you added the computed field to. This works because the POLYSTATS table has one record for every polygon. So for every record (in the computed field table) it looks for elements associated with it. Then it counts all the records in the POLYSTATS table that are associated with those same element(s). 
CBSOILS_Count.qry


Counts attached elements: Returns the number of polygons attached to each record. The CLASS table has some records attached to more than one polygon. The script assumes every value in CLASS.Class field is unique.

countAttachedPolygons.qry


Counts attached elements: Returns the number of polygons associated with the current record in the table you added the computed field to. 
Multi_CompFields_Count.qry


Returns area of largest attached polygon: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the area of the largest polygon. 
CBSOILS_Max_Area.qry


Returns area of smallest attached polygon: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the area of the smallest polygon. 
CBSOILS_Min_Area.qry


Returns average area of attached polygons: Add this as a new computed field to the CLASS table. For every record in the CLASS table, it gets associated elements, finds records in the POLYSTATS table associated with the same elements, and returns the average area. 
Multi_CompFields_Average.qry


Returns mean area of attached polygons: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the mean area. 
CBSOILS_Mean_Area.qry


Returns standard deviation of area of attached polygons: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the standard deviation of the area. 
CBSOILS_StdDev_Area.qry


Returns sum of area for all attached elements: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the sum of the areas. 
CBSOILS_Area.qry


Returns sum of area of attached polygons: Add this as a new computed field to the CLASS table. For every record in the CLASS table, it gets associated elements, finds records in the POLYSTATS table associated with the same elements, and returns the sum of the area. 
Multi_CompFields_AreaSum.qry
