Cross Tab Query with multiple Values

[chemicalbrother]

Hi everyone, thank you for taking the time to read this.

I am fairly new to Access but now have good understanding of a standard cross tab query. However I am trying to attempt to produce a cross tab query with multiple values.

Ultimately I am trying to get an output which has sales, margin and volume by month, by customer split down into 4 main categories (as seen in the attachment)

I have created 3 separate cross tab queries from a main 'data dump' query which will produce Sales, Margin and Volume individual but ideally I would like one output query which exports so I can export it straight into my Excel file.

To recap (looking at the attachment) I can produce columns A-H easily using a cross tab, and then duplicate for Sales and volume but would prefer one single output file.

Is this possible? And if so how?

Thanks again.

[ranman256]

I have a report table...tRptXtab to collect all the crosstab data...

make a macro to:
empty the table
I would append the 1st crosstab MARGINS to it (in your attached layout)
then append Sales (into its columns)
then Volume.
your final output to excel would be a summation query on the rpt table. Transferspreadsheet...