Access 2002 PivotTable Wizard

[Rick]

In trying to use the PivotTable Wizard after selecting the
query that I want to base my pivot table on and moving on
to the design view of the pivot table I have a blank
screen. It doesn't show any of my drop field selections
(Filter, Column, Row, etc.). I have searched on the web
for an answer but have not been able to find anything.

 

[Drew]

-----Original Message-----
In trying to use the PivotTable Wizard after selecting the
query that I want to base my pivot table on and moving on
to the design view of the pivot table I have a blank
screen. It doesn't show any of my drop field selections
(Filter, Column, Row, etc.). I have searched on the web
for an answer but have not been able to find anything.
.

Does your query actually return records? Open the query
and first make sure that it shows records when run. THe
Pivot Form are very straight forward and very easy to
create without the Wizard. Attach the query you want to
display the data for as the forms Record Source. Then
drop what whatever fields you wish to have available on
the pivot form onto the form. Go to the forms properties
and make sure that only Pivot View is "Yes". The rest is
all down hill.'

ds