Sorting data via query.

[BillBee]

I wanted to attach a file but even after eliminating unnecessary data it is still to large (1350kb). I am trying to sort records from 8 different Sections. I have done that all right with a query on each section. What I want to do next is to select from those 8 sections just the sections which contain 3 or more names. I have tried bringing all Queries to a new query with using >2 in the Criteria but that doesn't work. The field I am working with to Count is a Number field on the NameID. Is it possible to achieve a result for this. Thanks

 

[Galaxiom]

What do you mean by Sections?

 

[BillBee]

I have been working for some time on an application relating to showing birds. I have a table called Sections where there are eight species of birds from which I am trying to sort out the Novice winners from these groups of birds. There must be 3 or more exhibitors in each Species grouping before the exhibitor gains points towards Champion status. I probably used the term Sections a little incorrectly for this Forum as I was referring to Yorkshire Section, Budgerigar Section etc.

 

[Galaxiom]

How is your database related? What are the tables and their fields?

 

[BillBee]

Tell me how to attach a file size 1350kb this is with all the unnecessary data removed. It is a little awkward to explain relationships and name all the fields. There are 5 Tables and from 4 to 11 fields in these tables

 

[stopher]

Tell me how to attach a file size 1350kb this is with all the unnecessary data removed. It is a little awkward to explain relationships and name all the fields. There are 5 Tables and from 4 to 11 fields in these tables

have you run the "compact and repair" tool and the zipped you file?

 

[Galaxiom]

How about posting an image of the Relationships window?

 

[BillBee]

Tried to attach an image (in Word) of relationship but it did not appear on Post.

 

[BillBee]

can anyone please explain how I send an attachment

 

[BillBee]

Have attached File. Queries show each "Section" where I have sorted Novice Exhibitors. I want now to sort the "Sections" to include only those which contain 3 or more exhibitors. From that point I wish to select the Best Novice. Thanks for any help.