Query on summing

[GregVB]

When i'm summing up values in a column like "Hours:[production]+[nonproduction]" how can i have access treat blanks as zeros? I tried
"Hours: IIf([nonproduction]="",0,[nonproduction])+IIf([production]="",0,[production])" and it just gave me a #value error

 

[pbaldy]

Try:

Hours:nz([production],0) + nz([nonproduction],0)

 

[GregVB]

that worked. Thanks