Help Needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a question.I have two fields A and B and I want to write a condition
such that
if A = 0 then B = 1.Is it possible?

Also I have fields C ,D,E,F.I want to check if the F field is the sum of (c
d e).How should I do this.
Thanks.
 
if its for a select query then try that

select A,B,iif(A=0,1,B) as B_New, iif((C +D + E)=F, True, False) as Check_F
From .....
 
Back
Top