Question Access 2007: How Do I Export Calculated Fields from a Pivoted Query into Excel?

buick301

New member
Local time
Today, 09:58
Joined
Feb 21, 2009
Messages
1
I've tried and tried, and it seems that Access will not export calculated fields from pivot tables. Is there a simple work around for this that doesn't involve VB code?
 
Use the crosstab query as the record source for a make table query, See if the Calculation are in the table, if so then export from there.
 

Users who are viewing this thread

Back
Top Bottom