Brad Marks
BradM at blackforestltd.com
Thu Sep 26 14:31:48 CDT 2013
Rocky, There is a fixed number of Parts Categories. Eight of them in real life. I only showed 3 for my example to keep it simple. Also, there are about 15 other fields that are on the report that I did not show in the example. These all need to be shown at the sub-total level, also. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, September 26, 2013 2:28 PM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=2A1A228CAB.5A64A