Hello,
I'm new here, but plan on being active...im eager to learn and will help when i can.
I have a database that stores student information, funding, and student advisors
the student table and advisors table are linked through a table called student advisors, which contains just two fields (studentID & facultyID). a student can have one or two advisors.
I have a query that displays all active students & some additional fields found in the student table, such as email address & phone number. i want to add a column for their advisor(s). this field should be just the faculty last name. however, if the student has two advisors, then i want that field to be a combo of both advisors last names (faculty1lastname & " / " & faculty2lastname)
i have some programming experience, so i can pretty much follow whats going on in code, but not much with VB or access, so im not sure how to write this or even where to begin
any suggestions?