CrossTab Query with greater than 3 row headers / Excel Transpose

[Mimi]

Hi all, Does anyone know how to build a crosstab query with more than 3
headrer rows. The wizard restricts to 3. I would like to covert large
vertical excel files into horizontal tables using access crosstab or even
transpose function in excel. Does anyone know if either access crostab query
or excel transpose function can be used on large datasets?

 

[Ed B]

Hi Mimi,

If, after using the wizard, you open the crosstab query in design view, you
will see the three header rows. Using them as a template, you can see how to
add new header rows.

Good luck,

Ed

 

[Mimi]

Thanks Ed. This worked like a charm!

Hi Mimi,

If, after using the wizard, you open the crosstab query in design view, you
will see the three header rows. Using them as a template, you can see how to
add new header rows.

Good luck,

Ed