Hi,
Can you please tell me how I can do a IF in a query design view.
Basically I have a query as follows:
ColA ColB ColC ColD
12 14
11 10
In ColC: If (ColA-ColB>0, ColA-ColB, 0)
In ColD: If (ColA-ColB<0, ColB-ColA, 0)
Please suggest if there's a simpler alternative
thank you.
Can you please tell me how I can do a IF in a query design view.
Basically I have a query as follows:
ColA ColB ColC ColD
12 14
11 10
In ColC: If (ColA-ColB>0, ColA-ColB, 0)
In ColD: If (ColA-ColB<0, ColB-ColA, 0)
Please suggest if there's a simpler alternative
thank you.