Query not calculating all fields

[koncreat]

I have a table with 5 fields. One is the key which is auto number and the other are numeric value fields. When someone enters data they won't necessarily enter a value for each field. The field names are:

Cast


Finishing
Machined
Assembled

The problem I am running into is when I create a query so I can get totals the query is only showing what is entered in the first field in the table, cast, even if the other fields a value entered or not. The field name in the query for the total is Suspect and the calculation I am using is:

Suspect: Nz([Suspect_Cast],"0"+Nz([Suspect_Finished],"0"+Nz([Suspect_Machined],"0"+Nz([Suspect_Assembled],"0"))))

[pbaldy]

Each Nz() function should be used on a single field, and don't surround the 0 with quotes.

Nz(FieldName, 0)

[Peter M]

Baldy's correct about what is going wrong with your formula but if the datatable is configured to not allow nulls then there will always be 0 or a value and you don't need to use NZ. (Under Table Definition, set Required=Yes)


SuspectTotal = [Cast]+ [Finishing]+[Machined]+[Assembled]