Calculation problems

[Guest]

Hi All,

i am using an order form system mostly taken from the northwind orders
forms. The main difference is that i'm using it so my coworkers can create a
report and keep record of orders made with our suppliers. The details part of
the form is made up of the following fields; [Part], [UnitPrice], [Quantity]
and [LinePrice]. As in Northwind [Lineprice] is a calculated value in the
underlying query.

Often the user does not know the unit price of the part. This causes
LinePrice to give an error, and obviously the following calulation [Total] to
give an error. The form will then not create a report and gives a runtime
error. The calculation in [LinePrice] is:
CCur(OrdersItems.UnitPrice*[Quantity]).

Is there a way that this calculation could display n/a or a blank instead of
an error. And also is there a way to get my report to ingore these errors and
display an n/a or blank.

Any help much appreciated.

TIA

Rico

 

[roger_delahaye]

In the formula, change UnitPrice to NZ(UnitPrice,0). This will convert
any null values to zeroes.

 

[Guest]

Excellent, thanks very much Roger.