Function error

[emir]

Hello, I have a problem. When I try to start my query, it show me error: the expression you entered has a funkcion containing the wrong number of arguments.
test:PTP Kept Amount: IIf([Absorbing]![Partija] is null and [Cash Collected]>=[PTP=DUG],[PTP=DUG],[Cash Collected], iif([Absorbing]![Partija] is not null and [Cash Collected]>=[PTP=DUG],[Cash Collected],[PTP=DUG]))

[orange]

You have joined a thread that is quite old. You may want to start a new thread.

In plain English what is it you are trying to represent?
In vba use the IsNull() function.

[June7]

Structure of the IIf() makes no sense. You have two complete IIf() statements. This is not proper nesting

Maybe:

IIf([Absorbing]![Partija] Is Null And [Cash Collected]>=[PTP=DUG], [PTP=DUG], [Cash Collected])


Advise no spaces or special characters/punctuation (underscore is exception) in names.

NOTE: split post to new thread.

[Perceptus]

How about
IIf([Absorbing]![Partija] is null and [Cash Collected]>=[PTP=DUG],[PTP=DUG],iif([Absorbing]![Partija] is not null and [Cash Collected]>=[PTP=DUG],[Cash Collected],[PTP=DUG]))