Displaying set records

[Phil]

I have created a report that details the following fields:
-Country
-Product
-Stock Number

I have created a sum to calculate the number of entries for each country so
that it has a breakdown of records per country. What I would like to do now
is to only show the records for a country where the number of products is
greater than or equal to 3 (i.e I do not want to be able to see in my report
the fact that Ethiopia only supplies my business with one product... where as
China supplies me with 34 products should be visible. At the moment all of my
records are showing)

Can this be done in a report or must it be filtered in the query stage...
your help will be greatly appreciated.

As always,

Phil.

 

[Maurice]

You should go for the query. Place your criteria in the field products > 3

 

[Phil]

I for got to mention the fact that the products are text not numbers so the
criteria greater than 3 won't work