Calculation

  • Thread starter Thread starter fipp
  • Start date Start date
F

fipp

I have a textbox that calculatas on an afterupdate event. I understand all of
that it is equal to [fpos]+[net]. What I am trying to do is if my result
returns a value >50 then I want to Subtract that value by 50 and multiply it
by -1
 
I have a textbox that calculatas on an afterupdate event. I understand all of
that it is equal to [fpos]+[net]. What I am trying to do is if my result
returns a value >50 then I want to Subtract that value by 50 and multiply it
by -1
Click to expand...

IIF([fpos] + [net]) > 50,-([fpos] + [net] -50), [fpos] + [net])
 
I have a textbox that calculatas on an afterupdate event. I understand all of
that it is equal to [fpos]+[net]. What I am trying to do is if my result
returns a value >50 then I want to Subtract that value by 50 and multiply it
by -1
Click to expand...

Is this what you want?

=IIf(Nz([fpos])+Nz([Net])>50,((Nz([fpos])+Nz([Net]))-50)*-1,Nz([fpos])+Nz([Net]))
 
That is exactly what I was trying to do and it works. I have now added the if
unit which is a text variable is = to "KOR" Or "PR" for some reason it does
not work. I started without using quotes and it didn't recognize when the
value was = PR or KOR. I then added the quotes and it now debugs it?


If Me!unit = "KOR" Or "PR" And Abs(Me!ydl) + Me!net > 50 Then
Me!startingpoint = -(Abs(Me!ydl) + Me!net - 50)
 
it works without the Or in the if part of the statement. Is it not possible
to put an Or in there?
 
I figured it out. Thanks for your help.

If Me!unit = "KOR" Or Me!unit= "PR" And Abs(Me!ydl) + Me!net > 50 Then
Me!startingpoint = -(Abs(Me!ydl) + Me!net - 50)
 
I figured it out. Thanks for your help.

If Me!unit = "KOR" Or Me!unit= "PR" And Abs(Me!ydl) + Me!net > 50 Then
Me!startingpoint = -(Abs(Me!ydl) + Me!net - 50)
Click to expand...

That's still not going to work the way you want. The AND operator is
"stronger" than OR so it will evaluate the following two conditions:

Me!unit = "KOR"
Me!unit= "PR" And Abs(Me!ydl) + Me!net > 50

and if either one of them is TRUE it will set startingpoint to your
expression.

You'll need to use parentheses:

If (Me!unit = "KOR" Or Me!unit= "PR") And Abs(Me!ydl) + Me!net > 50 Then
 
Back
Top