I just can't work it out

mcreedie

Registered User.
Local time
Today, 23:43
Joined
Feb 26, 2001
Messages
14
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom