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

Stuart McLachlan stuart at lexacorp.com.pg
Thu Sep 26 20:00:32 CDT 2013


1. It's a stand alone Access application.

2. The problem is not with tables, it's with more than 256 derived columns in a crosstab 
query.

-- 
Stuart

On 26 Sep 2013 at 19:39, Dan Waters wrote:

> Hi Stuart,
> 
> SQL Server tables will let you use tables with over 1000 columns.  Perhaps
> you could link to those tables?
> 
> Good Luck!
> Dan
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: Thursday, September 26, 2013 4:38 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access Report Sub-Totals - Need to Display
> Differently
> 
> I've just run into a problem creating a large crosstab and outputting to
> Excel.
> 
> I developed an application foir recording and analysing market research
> surveys.  One output is an Excel sheet derived from a crosstab with the
> questions as columns and individual responses as rows.
> 
> The latest survey has over 256 questions and Access won't create a crosstab
> with more than
> 256 columns.  :-(
> 
> I'm currently workng on VBA cod to generate multiple crosstabs with a
> maximum of 250 columns in each and writing the combined sets out to a tab
> delimited file.  
> 
> (It gets a bit tricky because there is not necessarily a one-to-one
> relationship between the rows in the various crosstabs)
> 
> --
> Stuart
> 
> On 26 Sep 2013 at 15:52, Gary Kjos wrote:
> 
> > Thanks Brad. I appreciate your fishing results query sample. I do 
> > mostly one off stuff and I use cross tabs a lot. I will sometimes have 
> > several of them run as subqueries to a main query that links the 
> > pieces together for the final presentation to the user which I 
> > generally do via an Excel output file.
> > 
> > Good luck.
> > 
> > GK
> > 
> > 
> > On Thu, Sep 26, 2013 at 2:39 PM, Brad Marks
> <BradM at blackforestltd.com>wrote:
> > 
> > > Gary,
> > >
> > > Just for you...
> > > ______________________________________
> > >
> > >  Date      Fish-Species     Nbr-of-Fish
> > >
> > >  9/30/2013   Walleye            06
> > >  9/30/2013   Northern           15
> > >  9/30/2013   Lake Trout         11
> > >  9/30/2013   Muskie             01
> > >
> > > ______________________________________
> > >
> > >
> > > Thanks for the tip on the cross tab query.  I haven't worked with 
> > > these much.  Only some preliminary experimenting a couple years ago.
> > >
> > > Brad
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com
> > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> > > Sent: Thursday, September 26, 2013 2:30 PM
> > > To: Access Developers discussion and problem solving
> > > Subject: Re: [AccessD] Access Report Sub-Totals - Need to Display 
> > > Differently
> > >
> > > Well a cross tab query does that. But not sure how that works with a 
> > > report since the columns are dynamic based on the data.
> > >
> > >
> > > On Thu, Sep 26, 2013 at 1:47 PM, Brad Marks
> > > <BradM at blackforestltd.com>wrote:
> > >
> > > > 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
> > > >
> > >
> > >
> > >
> > > --
> > > Gary Kjos
> > > garykjos at gmail.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=DAA9D28C9A.BF06C
> > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > 
> > 
> > 
> > --
> > Gary Kjos
> > garykjos at gmail.com
> > --
> > 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list