Hi,
I have data collected by a query as in attached file.
I need to create a report of city name i.e Berat , PeriodSemiAnnual i.e First 2002 (12002 in the table) and other data by summing rows where the PeriodSemiAnnual is the same.
For example first 2 rows of report should be :
Low Dose Pop Depo IUD Condoms
Berat First 2002 1147 36 133 102 2875
Berat Second 2002 992 20 113 68 7050
Regards
I have data collected by a query as in attached file.
I need to create a report of city name i.e Berat , PeriodSemiAnnual i.e First 2002 (12002 in the table) and other data by summing rows where the PeriodSemiAnnual is the same.
For example first 2 rows of report should be :
Low Dose Pop Depo IUD Condoms
Berat First 2002 1147 36 133 102 2875
Berat Second 2002 992 20 113 68 7050
Regards