count function problem, easy?

[drrehak]

brain fart... I know I am missing something easy.

I have a solution that comes up with a code based on the number of fields that are populated. easy enough with count function. My problem is that some of the criteria dictate that you can only count if 2 fields are both populated.

count (field A; field B; field C & field D)

i need to count 1 if field C and D are BOTH populated not either. is this possible without a case func?

[comment]

Try:

Count ( Field A ; Field B ) + not ( IsEmpty ( Field C ) or IsEmpty ( Field D ) )

[drrehak]

thanks. I'll try that.