Group by field in Access Report

nguyenthuy

New Member

Join Date: Sep 2010

Posts: 4
#1

Group by field in Access Report

Oct 28 '10, 08:22 AM

Dear all!
I have a problem when create a report in access as below
Data in query:

Code:

Ma Property Color month1 month2 month3 ..... 01 mm01 b1 1 2 3 ...... 02 mm02 b2 1 2 3 ...... 01 mm03 b3 1 2 3 ..... 01 mm01 b1 1 1 1 .......

............... ............... ........

I want to create a report with content:

Code:

Ma Property Color month1 month2 month3 ..... 01 mm01 b1 2 3 4 ..... mm03 b3 1 2 3 ..... 02 mm02 b2 1 2 3 .....

(the row which same Ma column, Property column, Color column then sum Month)

Please support me!
Thanks all!

Last edited by MMcCarthy; Oct 28 '10, 09:57 AM. Reason: added code tags to help formatting
Tags: None
colintis

Contributor

Join Date: Mar 2010

Posts: 255
#2

Oct 28 '10, 11:56 PM

Have you tried putting Ma to a group level above the other fields?
Comment

Comment