VBA code to Pivot data

C

Chase

What is the VBA code to set up a pivot on 2 columns of data from a Access
database as the standard pivot function does not provide the required result?
 
D

Douglas J Steele

I'm having a hard time visualizing a pivot on 2 columns. You need at least
3: one for the x axis, one for the y axis, and one to represent the
intersection. If nothing else, you could create a query that fills in the
number 1 on each row so that you get that 3rd column.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Chase said:
What is the VBA code to set up a pivot on 2 columns of data from a Access
database as the standard pivot function does not provide the required
Click to expand...
result?
 
C

Chase

I have 6 columns of data which are fixed and 2 that quire a pivot ie weeks
and volume per week. I only require subtotals on the 2 variables for one of
the fixed columns, hence my pivot problem.
 
Top