Hi All,
I need one of those phased calculations where the second part of a percent
calc only comes in above a certain value. Is there a mathematic function
that will ignore any number until it becomes positive so that I can simply
use (x - y), rather than iif or something similar?
Cheers.
Bill.
Douglas J. Steele - 24 Apr 2008 19:29 GMT
No. You'll need to use IIf.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Hi All,
>
[quoted text clipped - 5 lines]
> Cheers.
> Bill.
Bill - 24 Apr 2008 19:56 GMT