VB6 and Access. Cross tabs on the fly.

[richmarin]

I am using VB 6 and Access97.

I need to do the following job. I need the ability to create cross tabs
on the fly while in VB6. The important thing is that I must control
which column is first and where the total column is. What columm lands
where is all important.

Any suggestions on how to do this ?

...

[phhatwork]

Hi,

If you are generating SQL in your program, use the PIVOT clause of the
SQL statement to specify the column headings you want in the order you
want them.

The PIVOT clause is usually the last clause in a TRANSFORM SQL
statement and has the form PIVOT <pivotfield> [IN colhead1,colhead2
....]

HTH,

PH