Posted by Zzyzzyth on February 15, 2002 12:22 PM
I was under the impression that you could update the underlying data within a pivot table? Is this correct?
I am generating "Daily Activity" reports from an external database (Access 2000), and I would like for the user to be able to make corrections in the pivot table and reflect in the database. Am I designing the pivot table wrong?
No one responded to my recordset question, so I guess that's not possible, so I want to try and give pivot tables a try.
My ultimate goal is to be able to let the user make corrections to update the database without giving them direct access to the database itself. Any suggestions would be greatly appreciated.