which function do I need?

[csbalogh]

Hi,

In a database I have among others 15+15 global fields that determine the format a record will have in a (Preview) calculation field. ExpItem 1 - ExpItem Divider 1, ExpItem 2 - ExpItem Divider 2, .... ExpItem 15 - ExpItem Divider 15. With the help of GetField I determine what the result in the Preview calc. field will be. GetField(ExpItem 1) & (ExpItem Divider 1) & GetField(ExpItem 2) & (ExpItem Divider 2).... The problem is that the insertion of the value of (ExpItem Divider) is dependent on whether one (!) PREVIOUS and ALL (!) the subsequent fields are empty. So I need ExpItem Divider 4 only if GetField(ExpItem 4) is not empty, and neither is ExpItem 5-15. And so on. So whether or not its value is inserted in the Preview field dependends on the value of 15 fields for ExpItem Divider 1, of 14 fields for ExpItem Divider 2, of 13 fields for ExpItem Divider 3 etc.

Which function do I need to get a positive result only if n conditions are met simmultaniously?

Thanks.

csb.

[Razumovsky]

case(condition1 and condition2 and condition3 and condition4..., result if positive, result if negative)

hth

-Raz

[csbalogh]

The AND operator does not seem to work for me in the Case function (I mean condition1 AND condition2 etc). Should it? Am I doing something wrong?

csb

[Razumovsky]

Hmm, has always worked for me.

Post your calc.

-Raz

[-Queue-]

If you have compound conditions, i.e. x > 5 or x < y, be sure to enclose them with parentheses. Case[ (condition1) and (condition2)...], etc.

What exactly is your Case() statement?

[csbalogh]

Thanks all, it's working.

csb