G
Guest
I am trying to figure out how I can generate a report which counts records
grouped in intervals. the intervals are grouping by Age, in five year
increments, and separated by Male/Female. the report works fine (I have the
Age groups nested in the Gender groups), with the correct total counts, but I
can't figure out how to label which intervals the counts represent. To make
this clearer, I'd like the report to look like this:
Female:
Ages Count
0-4 3
5-9 6
10-14 4
15-20 10
etc
Male:
Ages Count
0-4 6
5-9 2
10-14 7
15-20 20
etc
What I am getting now is:
Female:
Ages Count
3
6
4
10
etc
Male:
Ages Count
6
2
7
20
etc
any thoughts?
thanks,
janaki
grouped in intervals. the intervals are grouping by Age, in five year
increments, and separated by Male/Female. the report works fine (I have the
Age groups nested in the Gender groups), with the correct total counts, but I
can't figure out how to label which intervals the counts represent. To make
this clearer, I'd like the report to look like this:
Female:
Ages Count
0-4 3
5-9 6
10-14 4
15-20 10
etc
Male:
Ages Count
0-4 6
5-9 2
10-14 7
15-20 20
etc
What I am getting now is:
Female:
Ages Count
3
6
4
10
etc
Male:
Ages Count
6
2
7
20
etc
any thoughts?
thanks,
janaki