Before you create your report, create a query with the criteria for each field as you want it. Then use the query as the recordset for your report instead of your table. If this is something your users will be doing, you can make it easier to establish the criteria by using a search form. Look at this tutorial for an the concept.

http://www.datapigtechnologies.com/f...earchform.html

Alan