Pivot Table Setup

[David]

Group, I have Access 2002. I am trying to create a pivot
table form. I can successfully create a pivot table form
in Access 2000, but not in 2002. In 2000, it took me to
Excel in the Pivot table design mode. In 2002, it appears
to stay in Access, and displays a blank screen with the
field list. I do not have a grid to place row, column,
page and data information. Excel does not open like it
does in Access 2000. From the form object section, click
on NEW, then PIVOT TABLE WIZARD.I do not believe it is the
way I am creating the pivot table. I follow the same
process, using the same fields in 2000 from another
machine and it works. Is ther an add-in or some settings
I need to change that will allow me to switch between
Access and Excel for pivot table functions?
Any help you can provide is greatly appreciated.

 

[Peter]

Hi David
I responded to this issue under the Pivot Table topic originally posted on 1/21/2004

----- David wrote: ----

Group, I have Access 2002. I am trying to create a pivot
table form. I can successfully create a pivot table form
in Access 2000, but not in 2002. In 2000, it took me to
Excel in the Pivot table design mode. In 2002, it appears
to stay in Access, and displays a blank screen with the
field list. I do not have a grid to place row, column,
page and data information. Excel does not open like it
does in Access 2000. From the form object section, click
on NEW, then PIVOT TABLE WIZARD.I do not believe it is the
way I am creating the pivot table. I follow the same
process, using the same fields in 2000 from another
machine and it works. Is ther an add-in or some settings
I need to change that will allow me to switch between
Access and Excel for pivot table functions
Any help you can provide is greatly appreciated.