Crosstab query - MS Access 2000

[paulmitchell507]

I understand the basic concept of a crosstab query i.e data in rows
and columns.

It it possible to generate a crosstab with groups of column headings
based on months? i.e. I would like to show individual products as the
row heading but each month represented by 3 column headings.

So the column heading would be,

leadcount, ordercount, ordervalue; leadcount, ordercount, ordervalue;
leadcount, ordercount, ordervalue

This would represent 3 months.

The results will be output to file and linked to a master spreadsheet,
so the look of the crosstab is not important.

Regards,

Paul

 

[Allen Browne]

See:
Crosstab query techniques: Multiple sets of values
at:
http://allenbrowne.com/ser-67.html#MultipleValues

 

[paulmitchell507]

See:
    Crosstab query techniques: Multiple sets of values
at:
   http://allenbrowne.com/ser-67.html#MultipleValues

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.











- Show quoted text -

Allen,
Thank you for the advice. The example provides the solution to my
problem.