VBA code to Pivot data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chase - 02 Sep 2005 16:39 GMT

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?

Reply to this Message

Douglas J Steele - 02 Sep 2005 19:00 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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?

Reply to this Message

Chase - 02 Sep 2005 19:34 GMT

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.

> 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
[quoted text clipped - 4 lines]
> > database as the standard pivot function does not provide the required
> result?

Reply to this Message