Working with pivot table properties

[Guest]

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.

 

[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.

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