Can't add row or column field in PivotTable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, when I try to create a Pivot Table in Access 2002, I am only able to add
fields to the "detail" section. If I choose to add a field or column, the
"add to" button is grayed and doesn't work. I have tried this following the
steps in the example "my first pivot table" or something like that from MS KB
and the same thing happens.

Does anybody know why I can't create PivotTables?

Thanks
 
Installing SP-3 fixed this,

Or perhaps it was a problem with a converted database... I created a new
database and then copied tables and queries from the old one.

Good luck!
 

Ask a Question

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.

Ask a Question

Back
Top