Hi,
I have what I think (hope) is a simple situation. I'm trying to edit data presented in a pivot table form. This form was created from a single query, and I'm able to edit the data when I view the query in Datasheet mode.
What do I need to do in order to view the results of this query as a PivotTable, and edit the values directly within that table? This is an item/color matrix, and the data I'd like to edit is numerical quantities (how many of each item to keep in stock in each color) which are stored in a junction table between the items and colors tables.
Thanks for any advice. Also, I can help myself once pointed in the right direction! I honestly just have no idea where to start though which is why I'm posting here.
I have what I think (hope) is a simple situation. I'm trying to edit data presented in a pivot table form. This form was created from a single query, and I'm able to edit the data when I view the query in Datasheet mode.
What do I need to do in order to view the results of this query as a PivotTable, and edit the values directly within that table? This is an item/color matrix, and the data I'd like to edit is numerical quantities (how many of each item to keep in stock in each color) which are stored in a junction table between the items and colors tables.
Thanks for any advice. Also, I can help myself once pointed in the right direction! I honestly just have no idea where to start though which is why I'm posting here.
