Needing something and getting something else....

Hi,

Kindly have a look at my example and do the help.

I have a database (MS Access) in which there are 10 Customers.

We have 2 products:

1) Leather Suitcase 2) Plastic Suitcase

2 Customers took Leather Suitcase & Plastic Suitcase ...while
4 Customers took only Leather Suitcase ... and
4 Customers took only Plastic Suitcase

The problem:

When I try to create a report using Crystal Reports XI to get the report to know who purchased only Leather Suitcase, I am getting all the data for 10 Customers showing all the 10 records ...?

How to solve this problem. I need only 6 rows to be shown because only 6 customers purchased the Leather Suitcase.

Please do help.

Sweetie.Use the Select Expert limit your record selection to only the customers that purchased leather

product is equal to Leather