Hello,
I have two questions.

1)
I have three columns in my report:
Year, Month, Age, Count

The output of this report should be in this format:

2008
Jan 1-10 5
11-20 10
21-30 3
..
100+ 8
Feb 1-10 ...
11-20
21-30
..
100+
...
Dec 1-10
11-20
21-30
..
100+


My query looks like this:
SELECT Year(borrowdate) as YEAR, Month(borrowdate) as MONTH, Age FROM Books ORDER BY Age

I created a count column in layout view and added countrows function to get a count. Right now my output looks like this:


2008
Jan 5 5
10 10
85 3
..
100 8
101 9
Feb 5 5
10 10
85 3
..
100 8
101 9
...
Dec 5 5
10 10
85 3
..
100 8
101 9

i.e. individual age count. How do i make my current output to my desired output?

2) I am creating a matrix report for age as well which shows variation from month to month.
e.g.

Age, Jan, Feb, Apr .... Dec
10 1 1
29 4 5
57 8 1
100 10 88
...
etc.
i.e. 1 borrower was age 10 jan, 1 was 10 in Apr. etc.

Again, i would to display in a range, i.e.

Age, Jan, Feb, Apr .... Dec
1-10
11-20 1 1
21-30 4 5
....
91-100
100+ 10 88


My query is like this:
SELECT YEAR(borrowdate) AS YEAR, MONTH(borrowdate) AS MONTH, AGE, COUNT(AGE) AS count FROM books GROUP BY YEAR(borrowdate), MONTH(borrowdate), AGE

How do i do that?

Also, when age is 0, i would like to display "<1" and then its count. If age has a null value the display "not determined" and then its count.

Any ideas would be really appreciated.

Thanks in advance,
J!