Novice
Windows 7 64bit 
Access 2010 64bit
I am creating a pivot table in Excel from a Query in Access. I have entered a caption field on the Properties tab in access but the columns that are expressions do not display those names in the pivot table in excel. Is there a way to get those captions to pull with the data?
The titles of the expression columns remain Expr1, Expr2 ...
VIP
Windows XP Access 2010 32bit
I've never used pivot table but my guess is no.
Want to provide project for analysis? Follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Using table data as button captions
Posting Permissions
Reply With Quote