B buick301 New member Local time Today, 09:58 Joined Feb 21, 2009 Messages 1 Feb 22, 2009 #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?
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?
Dennisk AWF VIP Local time Today, 14:58 Joined Jul 22, 2004 Messages 1,649 Feb 23, 2009 #2 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.
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.