Counting a blank value

[TheEnigma]

I have a query that is counting yes/no fields. There are 3 fields titled

InCall,
Arrangement,
Resolution.

I have a 4th column that calculates the sum of these 3 fields. The only problem is that when one of the fields is blank, the 4th column won't return a value at all, even though the other 2 fields have data in them.

Can anyone help me please? )

 

[scriverb]

You should use the Nz function to convert the Null values to zero because when you add any fields together the Null value errors out the expression.
Example:
Field4: Nz(InCall,0) + Nz(Arrangement,0) + Nz(Resolution,0)


Use this above example to set up your queries calculated column.

Bob Scriver

 

[TheEnigma]

Thanks Bob! )