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
Sorting data via query.
- Thread starter BillBee
- Start date
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.
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
AWF VIP
- Local time
- Today, 19:14
- Joined
- Feb 1, 2006
- Messages
- 2,395
have you run the "compact and repair" tool and the zipped you file?
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.
Similar threads
Solved
Query sorting
