discoverer query

[Quoted] Can anyone give me some suggestions about the following query which I would [Quoted] like to perform in Discoverer, as I do not find a way to do it (if it is possible at all?).

I would like to select a set of objects based on the number of occurences of [Quoted] these objects in another set of objects. I'll give an example:

Suppose I have a databse of species of birds, their number of sightings (over a specific time period) in a specific state. Now I would like to select those birds that have been sighted at least 5 times (condition "sighting >= 5", as datapoint), in at least 20 states (of the 50 or so that [Quoted] have been entered in the database). Using totals in a sheet I could identify [Quoted] the species by simply ooking at the counts. However I would like to have only the requested subset in the sheet.

Can anyone give me a hint as to how this can be done?

thanks

Raymond Received on Thu Apr 06 2000 - 11:09:03 CEST