Query MS Access

[and111]

Hi,

How would I create a query to find the list of classes a particular instructor must attend?

Thank you in advance.

[twinnyfo]

Query the classes table, and group by the instructor.

[Seth Schrock]

The SQL would look something like this depending on which fields you wanted to pull:

SELECT ClassID, 
ClassName,
Instructor
FROM tblClasses

You can create a form in datasheet view and use that as a subform on your instructors form using the Instructor field as the Master/Child link. You can also create a combo box that lists each of the instructors and then once you select the instructor, a report can be opened to list the classes that the instructor you selected needs to teach (I can give more detailed instructions for this method if you desire).

[and111]

Thanks, is there any way to show a specific instructor in the query instead of grouping them

[and111]

Hi, thanks Seth but it needs to be a query

[twinnyfo]

WHERE Instructor = '" & InstructorName & "'"

inserted after your FROM clause

[twinnyfo]

This is standard Structured Query Language.......

[and111]

Ok, once again thanks both of you for your help