If you are in MSQuery, then it sounds like you have a query table rather
than a pivot table - perhaps the pivottable is built off the querytable.

In any event, You should be able to do Add Criteria and limit the records
retrieved by Report Date.

--
Regards,
Tom Ogilvy

"Diggsy" wrote in message
...
I am very new to Pivot Tables. I was given responsibility to maintain a
pivot
table on a excel 2000 sheet that shows weekly sales from an Acess
database.The problem is that the report dates that you can see are all
checked off. I was hoping to limit the report to the past 4 weeks
only(Maybe
13)but I don't want to uncheck all the dates on the dropdown. I managed to
get into the Microsopft query and in the SQL view I found this query

SELECT WeeklySales.`Report Date`, WeeklySales.`SKU Description`,
WeeklySales.`POG Stores`, WeeklySales.`LW Total Units`, WeeklySales.`LW
Total
$`, WeeklySales.`Status Code`
FROM WeeklySales WeeklySales
WHERE (WeeklySales.`Status Code`='Active') OR (WeeklySales.`Status
Code`='Inactive')

Is there a way I can manipulate this to get the data I need or is there
another way of doing this?

Than you

Diggsy