Filter Pivot Table

[theSizz]

I'm unable to set up a simple filter for a pivot table. Here's what I've done. Created a query that asks the user for the begin date and end date of the search. The pivot table form uses this query as the record source. When I open the pivot table all the records are retrieved. I understand how to filter the records when I open the table in Excel, but I would like to filter the records in Access. Can someone help with the code or procedure.

Thanks