Help with expression with 0 numeric value

[Christine Pearc]

Could someone help me with an expression in a report? If the value of DispositionID (a numeric field) is 0, I don't want the 0 to be displayed - it should just show nothing. The closest I've been able to come is shown below, but obviously it is trying to show an empty text string (" ") instead of a blank numeric value.

=IIf(IsNull([DispositionID])," ",[DispositionID])

Help with the correct syntax will be appreciated!

Christine

 

[Mile-O]

Change " " to ""

 

[KenHigg]

=IIf([DispositionID] = 0,"",[DispositionID])

???
kh

 

[Christine Pearc]

Help with expression with 0 numeric value - Thanks

Thank you, Ken - that did it! Silly me really should have figured that out before!!