|When creating a query, you can use non-displayed columns to further sort your data. You do this by unchecking the box for that column.|
If you have 3 separate columns, each for a different degree you can use these hidden columns in the query to exclude displaying the student where a higher degree is present.
3 columns, AS, BBA, MBA.
If the student has an AS and a BBA your hidden column for the AS query would draw from the BBA column in the main table. In the criteria cell you would type something like this: "<> YES"....if "YES" is the keyword to show that they have that degree. Doing so will eliminate anyone with an AS aswell as a BBA.
Might be a little confusing reading this, it's much easier to show someone how to do this.