Access IIf statement using same-query value as determinant -
i'm trying create query in access yes/no determined greater than/less relationship of 2 other values in same query. example, if currentstock < maxhold, yes/no should equal false. if equal, should true.
this current effort, taken query design:
stocked: iif([current stock] (is greater than) [max_hold],false,true).
this different related questions in others detail inverse, i.e. how use yes/no determine value. issue i'm not sure how use input value of "currentstock" determinant yes/no, however.
or directly:
stocked: [current stock]>[max_hold]
or, if prefer:
stocked: cbool([current stock]>[max_hold])
Comments
Post a Comment