Skip to Content
0
Former Member
May 10, 2010 at 12:33 PM

compare two characteristics in Query

153 Views

Hi Experts,

I have to compare two characteristics in Query fields like (A)Approved Level of Job(contain values like 01,02,03,04) and (B)Required Level of Job(contain values like 01,02,03,04).

Now I have to do these calculations

If A>B =1

If A<B =0

And also in other case

If A=b then value 1

Of A =/= B then value 0

Please let me know how I can achieve this.

These values could be in A,B,C,D instead of 01,02,03,04 then in that case how I will calculate these comparison.

Thanks

Take care

Vishal sharma