D
Don
I have a collection of records that each have a
probability percentage.What I need to do is make a
subreport to insert on a report footer that will total by
month certain ranges. For example,
0-50%
51-75%
76-100%
The ideal display would be along the lines of,
August
0-50% 4 1000
51-75% 10 1500
76-100% 22 4400
September
0-50% 6 1200
51-75% 4 500
76-100% 20 6500
etc..
Currently there isn't any limit on the months listed, so
it will grow by one each month.
About the only thing I can think to do is to make a
query/report for each level (0-50% for example), but then
that doesn't lump a month's information together.
Anyone have an idea of an easy way to accomplish this?
Your suggestions are welcome.
probability percentage.What I need to do is make a
subreport to insert on a report footer that will total by
month certain ranges. For example,
0-50%
51-75%
76-100%
The ideal display would be along the lines of,
August
0-50% 4 1000
51-75% 10 1500
76-100% 22 4400
September
0-50% 6 1200
51-75% 4 500
76-100% 20 6500
etc..
Currently there isn't any limit on the months listed, so
it will grow by one each month.
About the only thing I can think to do is to make a
query/report for each level (0-50% for example), but then
that doesn't lump a month's information together.
Anyone have an idea of an easy way to accomplish this?
Your suggestions are welcome.