Working with pivot table properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top