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
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