Skip to Content
0
Former Member
Nov 07, 2008 at 06:41 PM

How to fix this?

12 Views

Hello,

I got two fields in DB with data like this....

Sal1 Sal2

10.0000 20.0000

.0000 100.0000

1000.0000 2000.0000

NULL 3000.000

If field value is 0 or null....i want to pick up other field value....

i got this if loop tp do....but this is not working..

What i need to change to fix this?.

if ({Command.sal1} <> 0 or isnull({Command.sal1}))then

{Command.sal1}

else

{Command.sal2}