DSXchange

Hi,

I have 2 source fields:

AAA,
BBB

my target field name is:

XXX

The logic to populate XXX target column like below:

if AAA = 255 ( BBB<0 THEN populate XXX= LOSS,but IF BBB >0 then populate XXX=PROFIT)

Else other than AAA=255 VALUES leave it blank.


Can any one help me to apply this in IF-THEN-ELSE statements.

If (AAA = 255 & BBB<0) Then 'LOSS' Else If (AAA = 255 & BBB >0) then 'PROFIT' Else ' '

AAA,
BBB

my target field name is:

XXX

The logic to populate XXX target column like below:

if AAA = 255 ( BBB<0 THEN populate XXX= LOSS,but IF BBB >0 then populate XXX=PROFIT)

Else other than AAA=255 VALUES leave it blank.

may be slightly more efficient

Thanks Ray...