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

Are the parts categories fixed to those three, or are there a variable
number of categories?

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, September 26, 2013 11:47 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access Report Sub-Totals - Need to Display Differently

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  

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com