Report Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey Everyone,
I have a database that scores points based on Quality Assurance scores. I
have designed a system when someone is marked wrong on their QA score, they
can challange the QA. When someone challenges the responce one of the fields
on the form is "# of Points Requested". The person who reviews this has a
field named # of points returned.
On my report it has both of these fields and in the report footer the total
points are sumed and we can get a % of points returned. My question is how
can i get it to only count records where the number of points is greater than
1 point???? I have tried a DCount however it counts everything in my
database and not in the date range selected from my query? Thanks for
anyones input!
 
Scott...
Try something like this in your report query. Add a calculated column.
OverOne : IIF(Somefield > 1, 1, 0)
Then in any footer...
=Sum(OverOne)
should yield the "count" of SomeField >1

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top