AnsweredAssumed Answered

Generate report grouped by year, month

Question asked by mayor on Aug 8, 2010
Latest reply on Aug 15, 2010 by mayor

Title

Generate report grouped by year, month

Post

Hello,

I got 2 tables called student & registration

Student (name, id_no, address……..)

Registration(reg_date, month_reg,  year_reg…….)

I have setup fields as below:

month_reg = MonthName(reg_date)

Year_reg = year(reg_date)

 

I want to generate the report  grouped by YEAR & MONTH using reg_date as example below

 

                Name                    Address                             Reg_date

2010

                January

                John                      Penang Street                   2.1.2010

                Michel                  Kuala Lumpur                    5.1.2010

 

February

                John                      Penang Street                   23.2.2010

                Michel                  Kuala Lumpur                    15.2.2010

 

Please, advise me.

TQ

Outcomes