I have one main table that feeds three queries named “Qry_MBA”, ”Qry_BBA”, and “Qry_AS”, and they all consist of (Student_ID, Student_Name, and Degree). How can I have one student to appear in Qry_MBA only, even though he or she have all the three Degrees? Or How can I have one student to appear in Qry_BBA alone, even though he or she have BBA, and AS Degrees? Would be great if I can get some help from here, on this issue! Thanks in advance.

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. For example: 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.