Hi,
I am using Access 2003... and I created a pivot table to view data from a query based off several tables. (Row headings: employees and the projects they work on, column heading: months of the year, data: hours billed to each project per month) The pivot table is very pretty and exactly how I wanted to view the data but I need to be be able to edit the data from within the pivot table view... is this even possible?
I was trying to find a solution via the online help.. I was reading about some "EditPivotTableObject" button but I don't see that button available anywhere. I'm not even sure if that is what I'm suppose to use.
Anyway if anyone has any ideas, I would really appreciate it!
Thanks,
Lissa
I am using Access 2003... and I created a pivot table to view data from a query based off several tables. (Row headings: employees and the projects they work on, column heading: months of the year, data: hours billed to each project per month) The pivot table is very pretty and exactly how I wanted to view the data but I need to be be able to edit the data from within the pivot table view... is this even possible?
I was trying to find a solution via the online help.. I was reading about some "EditPivotTableObject" button but I don't see that button available anywhere. I'm not even sure if that is what I'm suppose to use.
Anyway if anyone has any ideas, I would really appreciate it!
Thanks,
Lissa
Last edited:
