Calculation only displays when clicked.

[louisa]

Hi all,

I have a form which has a few calculations on which are:

TotalPrice - =Nz([Quantity])*([UnitPrice])

Then at the bottom to calculate it all:

=IIf(Sum([Quantity]*[UnitPrice])=0,0,Sum([Quantity]*[UnitPrice]))

This has been working perfectly fine however the TotalPrice is no longer calculating the UnitPrice x Quantity and the TotalCost isnt calculating as nothing appears in the TotalPrice. However when we click the fields the data is diplayed but only on clicking, if we leave the record and go back its back to blank again. Any ideas?

 

[pr2-eugin]

So you placed this in the Control Source of the Unbound Controls?

Why would you even use an IIF for the total? It seems logically absurd ! You say if Sum is 0, put 0 else put the value. Would that not be the same as just leaving it as Sum?

 

[louisa]

Yes it is in the control source.

I am not the creator of the db in question so cannot comment regarding the calculation.