combine isnull not isnull

[basilyos]

hello guys
i want to combine (isnull) and (not isnull) in query

iif(isnull[txt1] and not isnull[txt2];true;false)

but it's not right

any help?

 

[Minty]

You need () around the test expression;

iif(isnull([txt1]) and not isnull([txt2]),true,false)

 

[basilyos]

sir am getting this error
the expression you entered has an invalid .(dot) or ! operator or invalid parentheses
You may have entered an invalid identifier or typed parentheses following the Null constant

this is my code

IIf(IsNull([Phone]+[Mobile]);;IIf(not IsNull([Phone]) and IsNull([Mobile]);[Phone];IIf(not IsNull([Mobile]) and IsNull([Phone]);[Mobile];IIf(not IsNull([Phone]) and not IsNull([Mobile]);[Mobile] & " - " & [Phone];))))

am checking four status
phone is null and mobile is null
phone is null and mobile is not null
phone is not null and mobile is null
phone is not null and mobile is not null

 

[Minty]

You are making this wayyyyy too complicated. What do you want to display based on these checks;

phone is null and mobile is null - Display ?
phone is null and mobile is not null
phone is not null and mobile is null
phone is not null and mobile is not null

 

[basilyos]

You are making this wayyyyy too complicated. What do you want to display based on these checks;

phone is null and mobile is null - Display ?
phone is null and mobile is not null
phone is not null and mobile is null
phone is not null and mobile is not null

in the first check nothing
second check mobile
third check phone
fourth check phone and mobile

 

[Minty]

Then you only need to check both once and the other values on their own.

DisplayedNo: Iff([Phone] Is Not Null And [Mobile] Is Not Null,[Phone] & " - " & [Mobile],IIf([Phone] Is Null,"",[Phone]) & IIf([Mobile] Is Null,"",[Mobile]))