Stuart McLachlan
stuart at lexacorp.com.pg
Sun Sep 29 16:25:14 CDT 2013
Yes they do. And it's not a "report" it's a form of "data dump". They need all of the data denormalised with one row containing all of the responses from one questionnaire) so that it can be imported into applications such as SPSS. (It's slightly more complicated than that, but that's the underlying concept) -- Stuart On 29 Sep 2013 at 8:44, Susan Harkins wrote: > I'm going to get hammered for this, but... it's what I do whenever something > just seems too difficult -- are you sure the people requesting this report > really need 256 derived columns? Sometimes what people ask for and what they > need aren't the same thing. I'm finding it hard to believe that anyone could > really make much use of a report with 256 columns. I'm not saying they don't > need and use all that data, I'm suggesting, they could do with a much > simpler report, if guided that way. :) Just a thought. > > Susan H. > > > > 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. > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >