Query creteria with or

[ootkhopdi]

how can i use this creteria in select query
i have two forms
1-emp
2-income detail
on both forms (text17) is same
i want to set creteria
is value of [forms]![emp]![text17] is null
then set creteria is [forms]![income detail]![text17]
if both are null then shows 0
i use this formula but it wants value of [forms]![emp]![text17] each time

Like IIf(IsNull([forms]![emp]![text17]),[forms]![incomedetail]![text17],[forms]![emp]![text17])

how can i solve this prob..

 

[JHB]

Something like:

IIf(IsNull([Forms]![emp]![text17]) And IsNull([Forms]![incomedetail]![text17]), 0, IsNull([Forms]![emp]![text17]), [Forms]![incomedetail]![text17], [Forms]![emp]![text17])

 

[ootkhopdi]

it shows "wrong number of arguments"