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

Stuart McLachlan stuart at lexacorp.com.pg
Thu Sep 26 16:37:53 CDT 2013


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
> 




More information about the AccessD mailing list