[AccessD] Crosstab question

Darryl,
Interesting approach.  The report my client wants me to make is now done
with Excel.  So this would turn it all back over to Excel after having done
the data entry in Access.  Neat!

My main concern with your suggestion is the report formatting.  It isn't all
a homogeneous mass of data.  It needs to be grouped by at least one category
with subtotals and grand totals. And then the report formatting to make it
look like the other reports would be another issue.  I have some facility
with Excel (who doesn't?) but I'd like to stick with an all-Access solution.

Thank you,

Steve Erbach
Neenah, WI


On Wed, Jul 22, 2009 at 6:45 PM, Darryl Collins <Darryl.Collins at coles.com.au
> wrote:

> " My client needs rolling 12-month reports with the values broken out like
> a spreadsheet"
>
> So why not use a spreadsheet and push (or pull) the data into an excel
> pivot table.  PT's are much more powerful than x-tabs in Access.  You can
> open Excel and create a PT directly linked into your query.
>
> Best of both worlds. I do this a lot.
>
> regards
> Darryl.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
> Sent: Thursday, 23 July 2009 6:18 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Crosstab question
>
> Dear Group,
>
> I need to create a report in the form of a crosstab with 12 monthly
> columns.  The Crosstab query capability only allows one numeric value to be
> summarized per column...but the client would like to see three values
> underneath each month's heading.
>
> I thought that I'd construct a table for use by the report with
> de-normalized columns in clusters of three for Month1Quantity,
> Month1Calculation1, Month1Calculation2...Month2Quantity,
> Month2Calculation1,
> Month2Calculation2, etc.
>
>