Skip to Content
0
Former Member
Nov 16, 2006 at 06:29 AM

if...then...else formula

21 Views

Hi,

I have three characteristic fields in my query. I want to create a formula that will display the value in either field1 or field2 based on a value in field3. Example:

if field 3 = Yes then

display value in field1

else

display value in field2

end if

How do I do that?

Thanks,

MIG