= Subtotal (+/- 1)?

[JCross]

I have a subtotal that needs to be within 1 of my Total. Right now I have an If statement with

subtotal = total

but how do I change this to allow for an error of 1?

Thank you!

Jennifer

 

[Jack Cowley]

If (Me![Subtotal] + 1 = Me![Total]) Or (Me![Subtotal] - 1 = Me![Total]) Then....

 

[JCross]

Thank you, Jack.........but what if I want it anywhere in that range? The subtotal can be anywhere from = to 1 over or under, including fractions. Is there a way to do that?

jennifer

[This message has been edited by JCross (edited 04-12-2002).]

 

[Travis]

If ABS(Me![Total] - Me![Subtotal])<=1 Then....

 

[JCross]

Travis,

Works perfectly. Thank you.

Jennifer