I just can't work it out (1 Viewer)

[mcreedie]

I know this must be very simple but I am having a complete mental block. I have a table with three fields; Ward, Date and Dependency Score.

The data in the dependency score field will be either 1,2,3or4. what I want to do is work out how many of each score there are i.e. Like "1" and then add up each score and work them out as percentage i.e. 25% were 1, 22% were 2 and so.

I hope this makes sense and any ideas would be greatly appreciated.

Many thanks in anticipation

Rob McCreedie

 

[Chris RR]

I know someone will come up with a sleeker solution than this, but off the top of my head, I'd write a query with four additional fields, like this (code is approximate):
Score1:Iif([Mytable]![Score] = 1,1,0)
Score2:Iif([Mytable]![Score] = 2,1,0), etc (for 3 and 4)

Then you can write a second query based on this one, summing up Score1, Score2, Score3 and Score4, and creating whatever statistics you want.