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

What do you mean by Sections?

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.

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

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

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 tableshave you run the "compact and repair" tool and the zipped you file?

How about posting an image of the Relationships window?

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

can anyone please explain how I send an attachment

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.