Hide zero values

[Rzadziu]

Hello,



I have a issue to hide 0 values in my query.

Im using expression to conect two values Hard: [Val27] & "-" & [Val28]

Sometimes i'm getting result 0-0 or 312-0

It is possible to hide those zeros?? maybe by formating??

BR Marcin

[lfpm062010]

Using IIF and check for 0. Like this

IIF([Val27]=0,"", [Val27]) & "-" & IIF([Val28]=0, "", [Val28])

[Rzadziu]

Thanks for your help it work as i wish to have.

BR Marcin