I have set up a dataform for progress reporting at school. The fields are: First Name; Last Name, House Group; Subject; Class; Present Grade; Target Grade; Actions to take etc etc. Once pupils have entered their data, I need teachers to be able to search all records for a combination of criteria (as in a Boolean search), as opposed the one quick filter.
For instance, I would like to create a view which allows a head of house to pull out all the pupils in the school who are in his/her house-group, and within that range, select all pupils taking the subject 'chemistry', and within that, all pupils with a specific target grade. My problem is that I cannot work out how to set up appropriate sort / search combinations. if you could help me with this hypothetical example, I could apply the knowledge to other combinations of criteria.
Something which equates to a boolean search would be great.