Using an IF statement with text values. ??

[Dimwhit]

I'm starting to the an IF statement isn't what I need, but I can't find an answer in the help file. Here's what I'm trying to do:

Field1 is a pulldown menu with two values [Yes] and [No]. I want Field2 to pull data from one of two other fields (Field3 and Field4), based on the value of Field1. Here is what I wrote:

For Field2, the calculation reads: If ( Field1 = Yes ; Field3 ; If ( Field1 = No ; Field4) )

When I try to save it, it tells me that the field (Yes) and (No) can't be found. So I'm confused. If I had numbers, like 1 and 2, instead of Yes and No, it would work just fine.

Is there a better way to do accomplish what I'm trying to do?

[Genx]

You have to put text values in quotes i.e. "Yes"

And case might be easier here.

Case ( Field1 = "Yes" ; Field3 ; Field1 = "No" ; Field4)

[Dimwhit]

Figures it would be something so simple.

Thanks! You saved me.