Conditional Counting in reports

[bluke]

I'm building a report where the detail consists of 3 fields.

Sales forecast Actual sales Variance

The variance is a % ( .5% -.5% 10%, etc)

In the footer I need to create a control where the number of records in the details are counted based upon the variance %. (basically how many records are in the range of .5% and -.5%; how many are from .5% and .1% and how many are greater than .1% Can anyone help?

Thanks

Brian.

 

[Brianwarnock]

In the footer you will need to have a series of controls containg something like =sum(IIf([variance])>=0.5,IIf([variance])<=1,1,0))

Brian

 

[bluke]

I tried this andreceived an error message stating it contained the wrong number of arguments. Am I doing something wrong?

 

[Brianwarnock]

Ok syntax was not correct try somethink like, but with respect I'm trying to point you in the direction to go not write your code, how will you learn.

=sum(IIf([variance]>=0.5,IIf([variance]<=1,1,0),0)

Brian