Nested If statements

[mmikula]

I have been working with nested if statments and trying to find if there is a
limit to the number of nested IF's that you can have? I have 3 working and
when I add a fourth, the whole statement fails.

thanks for any info

 

[Peter Jamieson]

There's a limit of 20 levels of nesting, but you are a long way from that!

Can you post the field codes you are using here? You may find Graham Mayor;s
page at http://www.gmayor.com/export_field.htm useful)

 

[mmikula]

Thanks, Peter. After seeing this 20 number, I went back with the old fashion
highlighter and found I was missing a quote. When I added the fourth IF, the
end
quote was missing. Even with another set of eyes, it was difficult to keep
track of.
I have added an additional 7 IF's successfully. thank you, again.