Pivot tables (1 Viewer)

[AnnaFoot]

Hello,

Do pivot tables exist in Access 2000? I've jumped directly from 97 to XP, so don't know. My XP version, set with Access2000 as it's default, allows me to build pivot tables, but when i use the database on a true Access 2000 version the pivot tables aren't as it were.

Thanks - Anna

 

[Graham T]

Anna

Taken from the MS Knowledge Base:

PivotChart and PivotTable Views

Microsoft Access 2002 introduces PivotTable and PivotChart views to tables, queries, views, stored procedures, functions, and forms. You can now perform data analysis and build rich PivotTable and PivotChart view solutions more quickly than ever before. PivotTable and PivotChart views can be saved as data access pages that can be viewed by anyone who has Microsoft Internet Explorer 5 or later. You can also use subforms in PivotTable and PivotChart views in exactly the same fashion that they are used with forms in Datasheet view today. Developers will also find it easy to write code behind forms in PivotTable and PivotChart views and take advantage of new events available in PivotTable and PivotChart views.

What's New in Access XP

HTH

Graham