If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Translate if statement in query
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? |
Thread Tools | |
Display Modes | |
|
|