report filter search

[accesshelpme]

I have a report that shows 3 columns, clients, versions, products and vendors. How can i make it so a user can filter the report to show only certain info. forexample, only show the clients that have a certain product. or only show clients with certain versions. Any suggestions? I want to user to specifiy the contrants for the report.

[June7]

For parameterized query approach (query would be the RecordSource of report), review tutorials at http://datapigtechnologies.com/AccessMain.htm especially 'Build a Custom Filter in Your Form' and 'Creating a Basic Search Form' in Access Forms: Tips and Techniques section.