Need per unit calculation

[Guest]

A subform consists of multiple categories of labor postitions, the unit
number of each, and the total cost per catagory. The third field calculates
the cost per unit (ie. $75K for 3 supervisors = $25K per unit. The main
form calculates the grand total labor cost of all the catagories and returns
an average value based on total number of units.

The query only works correctly if data for each catagory is "not null".
When, for example, no supervisors are being accounted for no return value is
calculated on the main form for the average cost per unit.

Letting a pro do the work. Thanks!!!

 

[Rob Oldfield]

You want nulls to count as zero? Look at the nz function.

 

[Allen Browne]

Or is the problem that those with no matching records have no record in the
query?

If so, you need to use an Outer Join in your query. Details in:
The Query Lost My Records! (Nulls)
at:
http://members.iinet.net.au/~allenbrowne/casu-02.html