469,270 Members | 1,728 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

Lose Grand Total Field when Exporting Form to Excel

Hi,
I'm using Access 2003 on Windows XP. I have created a PivotTable View Form and at the bottom is an automatically inserted Grand Total row. I added sum and avg fields and then hid the details so the Grand Total row actually shows totals for each column. It displays perfectly in Access but when I export it, the entire Grand Total row is gone.

What can I do to make the PivotTable Form export exactly how it displays in Access?

Thank you.
Jun 6 '07 #1
0 1313

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Jacky11 | last post: by
4 posts views Thread by lyndsey | last post: by
2 posts views Thread by Bytesmiths | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.