comparing two queries in Access DB

T-boy February 10, 2009 at 15:11:27
Specs: Windows XP
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.

See More: comparing two queries in Access DB

Report •


#1
February 12, 2009 at 01:06:56
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.


Report •
Related Solutions


Ask Question