MS Access SQL Query Question?

[jacksk58]

I've been searching around the Internet for an answer to a question I have.

I have these 2 tables in a one-to-many relationship in MS Access.

Please refer to the attached text file.

Thank You

 

[Colin@Toyota]

on the first line of your SQL, try:

SELECT DISTINCT professorFirstName,

etc.

 

[ajetrumpet]

Jack,

I'm not sure there is. The program queries by record, so your illustration kind of violates this. Maybe it would be better to view your results, say, in a form style? By doing it this way, you could avoid the traditional datasheet (record) presentation of the data, and present in such a way where you can see all classes taught by each professor. Getting a report printed this way would be of the same difficulty as well. Either a form or report would be easier than just a query display for something like this...