Touble Calculating Accuracy in a Query

[Gabriel2012]

Hello, so below is my issue.

I have a "CountoferrorID" field which I need to divide by the "Total Orders Booked" field in order to calculate an accuracy figure. These two fields are populated off of queries which have each stat broken down by accounting period, I.E 1,2,3 for each CSR. In this new query I need to calculate the data for the entire year, so I am using the "YEAROF" field to group by, and it works as far as counting all the "Error IDs" for the year and summing the "Total Orders Booked". However, when I enter the accuracy calculation it then breaks down each stat by period, does not show the period it simply lists each EIM multiple times, instead of by the year, any suggestions? See below...

[pbaldy]

It appears you're grouping by the accuracy field. Which value do you want for it (Sum, Max, Min, etc)?

[June7]

Need to see query SQL statements and maybe even sample of source data. If you want to provide db for analysis, follow instructions at bottom of my post.

Does the Accuracy calculation field have 'Expression' or 'Group By' selected?

[Gabriel2012]

My oh my, you solved it, many thanks .

[pbaldy]

Happy to help.