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 >