Transposing Cross Table Query

I

Ian

Does anyone have a method of transposing a cross table
query. It should be possible by building a SQL module.
However, this is beyond my programing capabilities. Does
anyone have one built or point me in the correct
direction to obtain the skills to build it myself.
Thanks
 
D

Duane Hookom

A crosstab is an un-normalized view of data. The first step to transpose
would be to normalize. This can be done with a UNION query. You can then
create another crosstab based on the union query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding my own rows to a Union Query without adding another table? 4
CrossTab Query with greater than 3 row headers / Excel Transpose 2
Two related select querys in series. How to design tables? 6
SQL queries on the Mac 0
Pivot Table View Query as Report? 2
Conditional Formatting 1
Query set-up not using cross-tab 9

Top