|
| 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
April 24th, 2008, 07:16 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Calculation Required
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. 
|
|
#2
April 24th, 2008, 07:29 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculation Required
No. You'll need to use IIf.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Bill" wrote in message ... 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.
|
|
#3
April 24th, 2008, 07:56 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculation Required
Blast!
Thanks. Bill
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
