If then help

  • Thread starter Thread starter Blueliner975
  • Start date Start date
B

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!
 
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...
 
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))
 
Back
Top