Rocky Smolin
rockysmolin at bchacc.com
Fri Sep 27 13:29:04 CDT 2013
Regardless of the number of categories, the only way I see to do this, without coding, is to put text boxes in the footer or section of the report, placing them where you want them, stretching them across the report, and bind them to one or more summation queries. Same with the 15 other fields. Myself, I would do this with some code, filling the boxes in the Format event of the section where the boxes are, but I find coding easier sometimes than trying to make queries do complex stuff. HTH Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Thursday, September 26, 2013 12:32 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Report Sub-Totals - Need to Display Differently 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com