Need to get percentage of an overall rating by different category #.

[CMooreJr]

I have a query that has a category number (10-60..10,20,30..) and in each category number there are several different lines that has different information for each category number(the number of lines varies) and each one has a rating number. I need to be able to get an overall rating per category number. I have even tried to do just a seperate query pulling each category number as needed. I am not having any luck.. and then I need to pull this info into a report.

any help on this is greatly appreciated.

 

[dhookom]

How about typing a few records (or pasting) into a reply and then how you would like the results to display?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.