Report Calculation

[scott04]

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!

 

[Al Campagna]

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."