MS Access table joining

May 20, 2011 at 22:00:36
Specs: Windows XP, Centrino Duo/2 GB
i have 2 is student "Result sheet".This table contains following fields: Registration, Name,Semester,Faculty and GPA. The other table is "Attendance" which contains Registration Number,Name and Attendance % .I have registration number as primary key in first one.what i want to do is create a query that will show me the names,faculty and registration number of students who have GPA>3.0 and Attendance>50%

Do i need to create a relationship for this.If yes,which one and with what setting and what query can i use to extract that specific list of information.I'm using office 2007


See More: MS Access table joining

Report •

August 15, 2011 at 00:14:47
My Dear, you have mentioned two table and in each of them you have a Registration number and a registration. Do those two vocabularies mean the same?

1. if yes, those numbers should not change and should refer to the same and unique person. Meaning in one table registration number should be a primary key and in the other table that same number should exist but as a foreign key in order to link the two tables.

2. if no, then you have to create a foreign key in attendance table in order to link the two table.

when that condition is satisfied, link the two tables and use the condition of GPA>3.0 and Attendance>50%.


Report •
Related Solutions

Ask Question