simple multiplication question

[aaronmarsh632]

Hi, I cant remember how to multiply 2 fields together.



I have a field called quantity, and a field called unitprice. then in the total price field i put for the default value

[Quantity]*[UnitPrice]

but this is obviously incorrect, and i cant find the answer anywhere

thanks

[dcrake]

What makes you think this incorrect?

The default value should be

=Val(Nz([Field1],0))*Val(Nz([field2],0))

I have added 2 elements, 1 to convert the contents to numeric values and another to replace a null value with 0 as something times nothing will raise an error.

David