Working with pivot table properties

M

MK

I'd like to be able to programatically get the values that are in a pivot
table cell, specifically the total cells but I'd settle for the detail cells.
Any help with this would be most appreciated.
 
T

Tim Ferguson

I'd like to be able to programatically get the values that are in a
pivot table cell, specifically the total cells but I'd settle for the
detail cells.
Any help with this would be most appreciated.
Click to expand...

SELECT COUNT(*) FROM MyBaseTable
WHERE SomeColumn = "SomeValue"
AND SomeRow = "SomeOtherValue"

A pivot table is, after all, just a bunch of DCount()s all lined up in a
square.

Hope that helps


Tim F
 
Top