Show nothing in a calculated control 1

[Fredgarner]

Is it possible to make a calculated control blank if the total is zero? It is straightforward to do this if the field is Null.

The calculation is =Sum([No of shares bought/sold]*[Current Price])

Miss Fred Garner

 

[genomon]

IIf(Sum([No of shares bought/sold]*[Current Price]) = 0,"",Sum([No of shares bought/sold]*[Current Price]) )

oughta do it!

The Microsoft mascot is a butterfly.
A butterfly is a bug.
Think about it....