I have a query where I have sorted some data but need to eliminate some more. I have more than two fields but it is only two which I am concerned with. The first is Class and the second is EntryNum. I have a Form that each time a Class is typed in I am able to have the EntryNum increase by 1. To explain further In tblEntries I may have 6 entries of 1 in the Class Field and In the EntryNum column would be 1, 2, 3, 4, 5, 6. In total there could be several hundred numbers in the Class field, with EntryNum ranging from 1 to 20 plus for each Class. What I want to do now, if possible, is to use the criteria or an expression in a Query that would only leave me with the Classes that have 5 or more EntryNum's assigned to each Class. Could anyone explain how this could be achieved? Thanks
Selecting a group of records in a field.
- Thread starter BillBee
- Start date
Brianwarnock
Retired
- Local time
- Today, 19:07
- Joined
- Jun 2, 2003
- Messages
- 12,701
Totals query
Group by Class, Count entrynum and put a criteria >4 for entrynum.
This will give you all of the classes you need and if you require the data from all of the rcords with those classes then join this query back to the table/other query on class
Brian
Group by Class, Count entrynum and put a criteria >4 for entrynum.
This will give you all of the classes you need and if you require the data from all of the rcords with those classes then join this query back to the table/other query on class
Brian
