"Total" Value Blank.

[Foster]

Hope this makes sense. It doesn't really to me!!!

I have some fields in a report which are (among many other's) Quantity1, Price 1, Total 1, Quantity2, Price 2 and Total 2. Total 1 multiplies the quantity1 and price1 together.............and the same for total 2.
I then have a TotalAll which is Total 1 +Total 2.
Basically, if there are no values for Quantity2 and Price2, the total 2 will be blank and the TotalAll does not return a value.

I think this is a long winded way of asking a simply question so I apologise!!!


Many Thanks.

F.

 

[Foster]

Sorry, just realised I have put this in the wrong forum!!
Yes I am a plonker......

Sorry.

 

[Pat Hartman]

If one of the fields in an expression is null, the result of the expression will be null. To resolve the issue, you need to use the Nz() function.

Nz(MyField1, 0) * Nz(MyField2, 0)