If statements

[theresa]

I volunteer for a non-profit service agency.

Is there a way to do an If calculation in a querie?

for example: if field(length of participation) is =1 then
insert the number 2 in this field. if field(length of
participation) is >1 then insert the number 4 in this
field if field(length of participation) is <1 leave it
blank.

I know in Excel that you only get 2 choices unless you
embed an if statement into the if statement.

=If(a1=1,2,if(a1<1,0,4))

thanks for your help

Theresa

 

[Duane Hookom]

NewColumn:IIf([LengthOfPart]=1,2,IIf([LengthOfPart]>1,4,Null))