Creating an If Then in a table

[Mommo]

I'm very new to Access and know almost nothing

I am trying to add a field within a table that will equal 1 if an adjacent field equals "yes" and 0 is the adjacent field equals "no"



I know in excel the equation is: IF(CELL="yes",1,0)

How would I apply this formula into access.

Again, I'm a newbie so if you could explain your answer that would be extremely helpful.

[June7]

Why?

IIf(field=Yes,1,0)

[Mommo]

Thanks a lot!