If then help

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!
 
S

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...
 
K

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top