Hi,

I have a pivot table based on an access query. It gives sales by month and
then a total by customer. The totals by customer vary from $100 to $100,000.
I want to be able to somehow filter out amount based on a dollar amount that
I type in. For instance, I only want to see those clients with totals
5000 or 50000. Is there a way to create an input box where I can type in a
dollar amount and have the report filter all amounts below the amount that I
type in?

Thanks,

--
Chuck W