The query has table [Demand] twice, with second instance having suffix _1 to
appear as [Demand_1] and they both check for nulls.
The same could be accomplished like this --
New Request: Nz([Demand]![Average requested],0)

Old Request: Nz(IsNull([Demand_1]![Average requested],0)


--
Build a little, test a little.


"Jazz" wrote:

I took both of these if statements from a query in an access database and I
am trying to interpret them.

New Request: IIf(IsNull([Demand]![Average requested]),0,[Demand]![Average
requested])

Old Request: IIf(IsNull([Demand_1]![Average
requested]),0,[Demand_1]![Average requested])

My interpretation is that each statement in the query is giving a field name
to the field and then doing something or nothing depending on the data in
TABLE: Demand / FIELD: Average requested, but I am not sure what. Are you
help to help me translate these statements completely?