Help Needed

[nikki]

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.

 

[Ofer]

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 .....