Difference

[Guest]

I have this code alread
If [Diff] >= 10 Then
[Amount Diff].Visible = True
Else
[Amount Diff].Visible = False
End If

how do I get it to work if is goes the other way.

I have a billed for amount and a total amount.
I then took the Diff of those. If it is a $10 diff in either direction I
want the Amount Diff visable. Right now I have it only +10
Thanks

 

[Guest]

Hi Chey,

Assuming [Diff] is a field you could try ...

If [Diff] >=10 or [Diff] <=10 then
[Amount Diff].visible = True
Else
[Amout Diff].visibile = False
Endif

 

[Guest]

I got it to work but I had to make it <=-10
Thanks

Hi Chey,

Assuming [Diff] is a field you could try ...

If [Diff] >=10 or [Diff] <=10 then
[Amount Diff].visible = True
Else
[Amout Diff].visibile = False
Endif
--
HTH

Chris

I have this code alread
If [Diff] >= 10 Then
[Amount Diff].Visible = True
Else
[Amount Diff].Visible = False
End If

how do I get it to work if is goes the other way.

I have a billed for amount and a total amount.
I then took the Diff of those. If it is a $10 diff in either direction I
want the Amount Diff visable. Right now I have it only +10
Thanks

 

[Douglas J. Steele]

If Abs([Diff]) >= 10 Then
[Amount Diff].Visible = True
Else
[Amount Diff].Visible = False
End If

 

[Guest]

Oops!!! My mistake. Douglas has an even neater solution than mine

Regards

Chris

I got it to work but I had to make it <=-10
Thanks

Hi Chey,

Assuming [Diff] is a field you could try ...

If [Diff] >=10 or [Diff] <=10 then
[Amount Diff].visible = True
Else
[Amout Diff].visibile = False
Endif
--
HTH

Chris

I have this code alread
If [Diff] >= 10 Then
[Amount Diff].Visible = True
Else
[Amount Diff].Visible = False
End If

how do I get it to work if is goes the other way.

I have a billed for amount and a total amount.
I then took the Diff of those. If it is a $10 diff in either direction I
want the Amount Diff visable. Right now I have it only +10
Thanks