[AccessD] Access Report Sub-Totals - Need to Display Differently

Brad Marks BradM at blackforestltd.com
Thu Sep 26 13:47:27 CDT 2013


All, 

I have an existing Access 2007 Report which shows sub-totals for "Part
Categories" like this. (Detail records are not shown) 

______________________________________

Date      Part-Category   Nbr-of-Parts

9/1/2013   Rings              10
9/1/2013   Pins               50
9/1/2013   Medallions         25

______________________________________


Recently there has been a request to display this data on the report in
a different fashion,  with the "Parts-Category" being shown in the
heading like this and then have only one line for each date.

______________________________________

Date       Rings   Pins    Medallions

9/1/2013    10       50      25

______________________________________

I would like to use Access reporting "Built-in" features to do this.

Any ideas/advice?

Thanks,
Brad  



More information about the AccessD mailing list