J
Justin
I have received so much help from you guys earlier and it has helped me
tremendously! However, I am stumped again.
I am trying to create a query that will take some student data that I get
from a previous query and have this information compared to a table that
contains all of our course information. I am trying to get these accounts
created for our online students.
Query # 1 (which works thanks to your help!) takes student information and
compares it to a seperate table of students who have already been set up with
an account. I am going to use the info from query 1 for query 2, which will
put the new students in to their correct courses.
New student 1 is enrolled in a EH 106 course. I need the query to pull the
student's name, e-mail address, etc., but most important of all, i need the
query to pull the EH 106 information (Instructor's name, instructor's e-mail,
course name, etc.)
In the end, this will be used for an upload to our course management system,
as well as a mail merge file.
I appreciate the help!
tremendously! However, I am stumped again.
I am trying to create a query that will take some student data that I get
from a previous query and have this information compared to a table that
contains all of our course information. I am trying to get these accounts
created for our online students.
Query # 1 (which works thanks to your help!) takes student information and
compares it to a seperate table of students who have already been set up with
an account. I am going to use the info from query 1 for query 2, which will
put the new students in to their correct courses.
New student 1 is enrolled in a EH 106 course. I need the query to pull the
student's name, e-mail address, etc., but most important of all, i need the
query to pull the EH 106 information (Instructor's name, instructor's e-mail,
course name, etc.)
In the end, this will be used for an upload to our course management system,
as well as a mail merge file.
I appreciate the help!