Logical Function Calculations

[jdhunter]

I'm trying to create a calculation (logical function) using the case function. What i want to do is create a calculation that gets information from two fields then turns that information into another field.

So what i want is

Case (Field 1 = "A" and Field 2 = "B" ; 3)

What i don't understand how to do is create the AND part of the equation so that i can incorperate more than one field into the logical function.

Also is there a way to do the same way but with the > or < functions. Thanks a bunch.

Jonny

[Ender]

Your case() function as written will work. < and > operators work too, but it's not clear what you plan on using them for.

[CoZiMan]

Well, it would work if there was a DEFAULT value specified after the 'AND' statement is evaluated.

I STILL copy the different statements form the pull down list and then replace the individual terms from my database, even though I have them pretty well memorized. That would show you need another semicolon and a default value before the closing quote.

And, yes, there would be an error message pop up if this was what you had in the calculation.

[Ender]

The default result is optional for case() and if() statements. There is no error message that pops up if it's missing.