Sum in a report

  • Thread starter Thread starter Fipp
  • Start date Start date
F

Fipp

I am trying to find the sum of the number field [yards]
where [passzone]=1 and [compinc]="1"

This is in a footer section of a report called "passzone"
The report is based off a query called "allpassplays"

I also want to know the number of times where
[passzone]=1
[passzone]=1 And [compinc]=1

for those I have the following and they appear to be
working correctly.

=Abs(Sum([passzone]=1))
=Abs(Sum([passzone]=1 And [compinc]="1"))

Thanks for the help!
 
Back
Top