Hale, Jim
jim.hale at fleetpride.com
Wed Jul 2 11:29:08 CDT 2003
Did you create it using the Pivot table wizard? If so I have never found a way to add fields after the fact that the pivot table would recognize. I've quit using the wizard altogether and have gone to excel templates that I refresh through code. These spreadsheets can easily be changed to accommodate new fields. Jim Hale -----Original Message----- From: Susan Harkins [mailto:harkins at iglou.com] Sent: Tuesday, July 01, 2003 5:49 PM To: AccessD at databaseadvisors.com Subject: [AccessD] updating PivotChart's query I based a PivotChart form on a query. Then, I returned to the query and added additional fields to it -- but the PivotChart's Field List won't reflect the new fields. Is there anyway to update the fields or do you just have to start over? That seems a bit convoluted. :( Susan H. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030702/46dc7109/attachment-0001.html>