Formula in Report Footer

[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!

 

[Guest]

Is Dcount the correct function? or is there a better function?

 

[John W. Vinson]

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!

I'd suggest adding a calculated field in the Query upon which the form is
based:

GTOne: IIF([points] > 1, 1, 0)

This will be 1 for each point which should be counted, 0 otherwise. You can
put a textbox in the footer with a control source

=Sum(GTOne)

Sum - not count - because Count counts all records, zero or otherwise.

John W. Vinson [MVP]