Jim Lawrence
accessd at shaw.ca
Fri Sep 27 15:27:56 CDT 2013
Is there anyway to predefine the extend of the results? IOW is there a fixed number of options or are the items variable. If there are a fixed number of specific items then the spreadsheet can be built beforehand with all the options and rows without data can be turned off after the crosstab process is completed? Jim ----- Original Message ----- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, September 26, 2013 2:37:53 PM 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