Summing fields in Access 2010 reports

[bannonymous]

In a report I want to total 'Quoted Material' and 'Add-On Material' for multiple records. When a record does not have a value in both these fields the total is incorrect. I do not want my report filled with a lot of unnecessary zeros. How do I tell the report to regard the null field as being equal to zero?

[pbaldy]

Nz(FieldName, 0)

[bannonymous]

Thank you for your suggestion. I apologize for my ignorance, but I am not sure exactly what you mean. I went into the report design and changed the command to =sum([Quoted Material,0]+[Add-On Material,0]) but got an error message. Ditto with trying to put the ',0' in the fields used to get the summation.

What is Nz? Do I enter the full 'Nz(FieldName, 0)'? Where do I enter this change?

Thank you very much for your time and assistance.

[pbaldy]

Did you look in Help? Nz() is a function that replaces Null values. Try

=sum(Nz([Quoted Material],0)+Nz([Add-On Material],0))

[bannonymous]

You are marvelous! Thank you!!

Yes, I did look in the Help function, but sometimes you don't know enough to know where to look.

[pbaldy]

Happy to help, and welcome to the site by the way!