I am trying to define a query to show only certain records based. Here is my best analogy to describe what I am attempting:
A school where all students must take an english class. They may also take a variety of other classes. I am attempting to filter out only those students who are taking no other classes but english.
I'd like to be able to do this within the user interface so that I can describe the logic and show others if a change is necessary.
Anyone with ideas how best to proceed? I cannot manipulate the tables (read only). There are three tables related in this query. Is a query the best way to achieve this? I use Excel extensively to manipulate table-derived data so this is a process I will likely be doing again.