Counting/totalling non-numeric fields

[mpreston14]

Hello,



In my soccer referee database, I am capturing a whole host of data, some of which is non-numeric but I still want to count the instances of that data. How is the best way to do so?

I have tried a couple of ways in the query, I even have tried converting the data to a number then counting it via an IIF statement:

Total_BU10_Matches: IIF([Match]=BU10,1,0) and setting the Total to Count, it sort of works, but its not just the BU10 matches, it counts all of the referee's matches. I have tried with and without quotes around BU10 and it doesnt impact the output.

I have tried putting criteria on the above but I get data type mismatch error messages.

I would like to have a column in the query that pulls the totals for each of the Match possibilities.

I have searched but the examples I have read haven't been similar to what I am looking to do, ie I didn't understand them

As always your help is greatly appreciated.


Mike

[June7]

BU10 must be within quotes because it is literal text.

Then use Sum instead of Count on the constructed field.

[mpreston14]

Worked like a charm! Thanks!