Hi,
a pivot-table in access is the result of a query - it is only a view on
your data!
The structure of your data is very different from the structure of the
pivot-table. Therefore you have to edit the data in the base tables of
your pivot-table.
When you re-open your query, you will see the altered data!
(Only in simple queries, access allows editing data - it's a special
feature of access! A database-system like oracle allows no change of
data in a view!)
Hi,
a pivot-table in access is the result of a query - it is only a view on
your data!
The structure of your data is very different from the structure of the
pivot-table. Therefore you have to edit the data in the base tables of
your pivot-table.
When you re-open your query, you will see the altered data!
(Only in simple queries, access allows editing data - it's a special
feature of access! A database-system like oracle allows no change of
data in a view!)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
