HELP: Compare Column values with column names in different tables
in [Forms]
|
Prev: Macro for Opening an Excel document
Next: Compare Column values with column names in different tables
From: sam on 25 May 2010 15:24 I have two tables, Grades_Table and Course_Table In Grades_Table, I have the following columns: Student_ID English Math Physics Chemistry Biology In Course_Table, I have the following columns: Course_ID Course_Name Now, I want to right a combination of SQL query and VBA to search specific students For E.g.: I want to view students who has a grade of “B” in Physics, “B” in Math and “B” in Chemistry How can I do this?? How can I grab a course from “Course_Name” column, from “Course_Table” then locate that course in Grades_Table (Here the course names are the column names)? Thanks in advance |