I have a field in my table Claim Quality Index which has file scores 3.0, 2.5, 2.0, 1.5, 1.0. I need to build a query that will give me the count of each of the scores above - I want it to show how many files were scored 3.0 in one column and how many files scored 2.5 in a separate column and so on. I also use the first column as my date of reinspection as I will need these counts by certain dates, quarter, yearly, or by audit. I use Between[Enter Beginning Date]and[Enter Ending Date] and choose the where as I do not need the dates to show I just need the data for that time frame.
I have used various formulas but I cannot seem to get them to work. I will use this query to feed other reports I have built into the database. I need these counts in order to calculate the CQI score we give to an individual, team, office, or audit. I have tried various IIf statements i.e., IIf([Claim Quality Index]=3.0,Count[Claim Quality Index],"") I get an error - I have also tried the DCount statement but to no avail either.
I hope someone can help me build this query or is the an SQL statement that could use?