If a value is negative how to make it equal 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marc - 31 Aug 2006 21:55 GMT

If I do a calculation between two fields and the answer ends up to be
negative how do I make the negative number equal 0.

Reply to this Message

Rick Brandt - 31 Aug 2006 22:04 GMT

> If I do a calculation between two fields and the answer ends up to be
> negative how do I make the negative number equal 0.

=IIf(YourCurrentExpression < 0, 0, YourCurrentExpression)

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Marc - 31 Aug 2006 22:24 GMT

=IIF([Finished Date Man BR by QA]-[Packaging Date]<0,0 [Finished Date Man BR
by QA]-[Packaging Date])

Is above how I'm suppose to write it? It give me an error "you may have
entered a comma without a preceeding value identifier" Thanks for your help.

> > If I do a calculation between two fields and the answer ends up to be
> > negative how do I make the negative number equal 0.
>
> =IIf(YourCurrentExpression < 0, 0, YourCurrentExpression)

Reply to this Message

Klatuu - 31 Aug 2006 22:42 GMT

You are just missing a comma. The construct for an IIf statement is
IIf(condition, True Value, False Value)

=IIF([Finished Date Man BR by QA]-[Packaging Date]<0, 0, [Finished Date Man
BR
by QA]-[Packaging Date])

> =IIF([Finished Date Man BR by QA]-[Packaging Date]<0,0 [Finished Date Man BR
> by QA]-[Packaging Date])
[quoted text clipped - 6 lines]
> >
> > =IIf(YourCurrentExpression < 0, 0, YourCurrentExpression)

Reply to this Message