If(not IsEmpty)

[thanks]

Hi All,

I have two fields, A & B

A is set to:

If ( IsEmpty ( database::A); "" ; "A: " & database::A

B is set to:

If ( IsEmpty ( database:::; "" ; "B: " & database::

Works well, if noting is found in A then no result is show and the same for B.

I need to be able to make so if a records is found in B then A is not shown regardless of whether it has data or not

This cal is beyond me so I'm asking for your help

Thanks Tony

[comment]

Do you mean:

If ( not IsEmpty ( database::A ) and IsEmpty ( database:: ) ; "A: " & database::A )

[thanks]

Not sure how to express it in a calculation but it needs to be:

I if data in A show A, if data in A and B then only show B

[Vaughan]

if data in A show A, if data in A and B then only show B

... or rephrasing this, if there is data in B then show it, otherwise show A.

Case( not isempty( B ) ; B ; A )

This assumes that if there is data in B but not A then B should be shown.

[thanks]

... or rephrasing this, if there is data in B then show it, otherwise show A.

Case( not isempty( B ) ; B ; A )

This assumes that if there is data in B but not A then B should be shown.

Cool understand the logic, how would I show B only, even if there was data in both A and B?

[Vaughan]

This does exactly that: if B is not empty, display B, else display A. The condition -- that B is not empty -- has no regard for what is in A.Thus it displays B whether A is empty or not.

[bruceR]

Cool understand the logic, how would I show B only, even if there was data in both A and B?

That's exactly what it does.

What happens when you tried it out for yourself?

Why do you say "Cool understand the logic" when - well, it seems you don't.

[thanks]

Doh, had the field round the wrong in my cal, thanks some much guys...

Tony

Edited June 18, 2010 by Guest