C
Chris Morrison
I'll try again....
I have a table called safety that has a column/field
called results, that has numbers in it from 0 thru 5. I
need to design a report that will count the number of
occurances for each 0 thru 5 answer, and a frequency
distribution of what % of outcomes there were - for
example - what % of the totals were 5,s, 4's, 3's, etc...
How can I do this as a report, and make it work? I
can do a total count for all records, and a total average
score for all the records, but I am absolutely stuck on
these other calculations.
I would like to have it look like this in the end (or
footer, or aggregate?) section of the report. I have
always had trouble using a cross tab report, I never can
get it to come out right, and I dont know if that is the
answer because I have to list a series of names in the
detail section of the report as well.
safety plan score count % of total
5 1 25.0
4 0 0.0
3 1 25.0
2 2 50.0
1 0 0.0
0 0 0.0
I hope this adequately explains the situation
This report is based on a query for the safety table that
runs for a user defined timeframe. Thanks for any
help/assistance someone can give me, it is greatly
appreciated.
..
I have a table called safety that has a column/field
called results, that has numbers in it from 0 thru 5. I
need to design a report that will count the number of
occurances for each 0 thru 5 answer, and a frequency
distribution of what % of outcomes there were - for
example - what % of the totals were 5,s, 4's, 3's, etc...
How can I do this as a report, and make it work? I
can do a total count for all records, and a total average
score for all the records, but I am absolutely stuck on
these other calculations.
I would like to have it look like this in the end (or
footer, or aggregate?) section of the report. I have
always had trouble using a cross tab report, I never can
get it to come out right, and I dont know if that is the
answer because I have to list a series of names in the
detail section of the report as well.
safety plan score count % of total
5 1 25.0
4 0 0.0
3 1 25.0
2 2 50.0
1 0 0.0
0 0 0.0
I hope this adequately explains the situation
This report is based on a query for the safety table that
runs for a user defined timeframe. Thanks for any
help/assistance someone can give me, it is greatly
appreciated.
..