Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I build a totals report?

Status
Not open for further replies.

LegionOfDarkness

Technical User
Jul 14, 2003
12
US
I have created an Access database for my department to monitor phone calls for Quality Assurance. I have set a from that lists all the criteria for each evaluation, and option groups for answers. I have added total feilds for each criteria for total possible points and total earned points. At the bottom of the form, I have the total percentage for the entire evaluation. I need to create a report that will summarize the department score for each citeria. This means I have to add up the score from every evaluation I create for every criteria.
Example: Question(Criteria) Average Plus/Minus YTD
3 Part greeting 30% -3% 40%

This will be a summary report of all the evaluations I do. Any thoughts on how to make this happen?
 
LegionOfDarkness,

Did you get a response for this request.



Sid from Minnesota
 
I'm not sure how anyone can answer this question without:
1) table structure
2) a few sample records
3) the desired display based on the sample records

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top