C
CAA
Hello all (have you got that Friday feeling!?)
I'm trying to compare an amount with another amount which has gon
through a long process of calculation, i cannot use the round functio
in VBA as this rounds my 1.333's to 1, which loses me just short of
every 3 times this happens.
So, is there a procedure i can write (Tolerrance) that i can slip a
the end of a query such as If a = b Tolerrance Then
Bring out the fatted calf, etc.
I know i could opt for: If a < b+1 And a > b+1 Then
Greece up the Monkey
But my dilema is, it's a whopper of a formula as it is, with AND's
Or's Not >'s
How do i go about writing something that will take an argument chrun i
and evalute, or even how do you pass this value to another procedure t
evaluate then pass it back to the point where it left with an A.OK o
NoWay.?
Thanks for looking
CA
I'm trying to compare an amount with another amount which has gon
through a long process of calculation, i cannot use the round functio
in VBA as this rounds my 1.333's to 1, which loses me just short of
every 3 times this happens.
So, is there a procedure i can write (Tolerrance) that i can slip a
the end of a query such as If a = b Tolerrance Then
Bring out the fatted calf, etc.
I know i could opt for: If a < b+1 And a > b+1 Then
Greece up the Monkey
But my dilema is, it's a whopper of a formula as it is, with AND's
Or's Not >'s
How do i go about writing something that will take an argument chrun i
and evalute, or even how do you pass this value to another procedure t
evaluate then pass it back to the point where it left with an A.OK o
NoWay.?
Thanks for looking
CA