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

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

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.

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