IF Statement

[outlaw318]

I have been trying and searching for hours on this I cant find the answer. I think Im close, but cant get it to work. I have a two number fields. "A" and "B" and a result field "C". I am trying to write a statement that says If A is greater than B, C should equal the number 1. I am trying to calculate test results that I can track the times that A is higher than B. Can any one help?

 

[Mile-O]

In the ControlSource of the C object - as you never specified what C should be if A is less than B I've ensured it returns 0:

=IIf([A]>,1,0)

 

[outlaw318]

Thanks worked great. I kept trying to add = "1" at the end. All I have to do now is figure how to keep a running total. For a "Win-Loss" Record.

Thanks

 

[Rich]

=Sum(Iif([A]>,1,0)) will give the total