help with calculation

[Gaz 007]

I have a claculation

If ( (accomtype = "Residence") and (IsEmpty ( Res Alloc::Apt Num ) = 1) ; "No" ; "Yes")

what I want to do is if the accomtype field is set to residence and the field Apt Num in the Res alloc table is empty then it should equal no otherwise yes at the moment it always says yes.

[Inky Phil]

HI Gaz

try this

Case(accomtype = "Residence" and IsEmpty (Res Alloc::Apt Num);"No";"Yes")

Phil

ps look up the case() function in your help files for a broader explanation.

[Gaz 007]

how would this work if i had 2 things to check

Case(accomtype = "Residence" and IsEmpty (Res Alloc::Apt Num); Case(accomtype = Hotel" and IsEmpty (Hotel Alloc::Rm Num);"No";"Yes")

is this correct, i want to be no if accomtype is residence and the apt num is blank or if the accomtype is hotel and rm number is blank otherwise it should be yes.

[rellis32]

Case( accomtype = "Residence" and IsEmpty ( Res Alloc::Apt Num ) ; "No" ; accomtype = "Hotel" and IsEmpty ( Hotel Alloc::Rm Num ); "No" ; "Yes" )

So your case statement is formatted like this:

Case ( test1 ; result1 ; test2 ; result2 ; default result )