If then help

[Blueliner975]

I have gotten some great responses on this IF THEN statements...

But i need someone who can walk me thru it... anyone available for some
advice via AIM YAHOO OR MSN messenger.

After which i will be posting the help on these forms to allow other users
to see it!

 

[Sean Timmons]

Not sure if you'd get any takers on that. If you are going to post the help
here, there is no need to use IM. Generally, responses are rather quick on
this site, so wait time should be minimal regardless...

 

[KARL DEWEY]

Nothing to walk through. Just use this formula --
IIF( Boolean Logice Test, Results if true, Results if false)
Like so --
IIF([Table1].[DataField] = 9, "Yes", "No")
In this case [Table1].[DataField] is a number field. Surround the numerial
character with quotes if [Table1].[DataField] is a text field.

You can 'nest' IIF statements like this --
IIF( Boolean Logice Test, Results if true, IIF( Second Boolean Logice
Test, Results if true, Results if false))