"=?Utf-8?B?S2V2aW4gV2l0dHk=?="
wrote in :
The interface seems to have ways to do
this, (AutoCalc and Calculated Details/Totals) but I can't get them to
work.
Like I said, I am no pivot table expert, and even less of one on the UI.
What if you set up the pivot on a query that included fields based on
appropriate DCount() or DSum() calculations? If the query runs like sausage
meat, it would probably be an appropriate use of a temporary table,
particularly if other people are doing updates at the same time.
Hoping someone else will butt in here...!
All the best
TimF
|