How do I make a query with repeat fields in one table fit in one l

J

john15243

I have 2 tables. One is teachers and the other is students. How can I get a
query to have one line with one teacher's name and the different students
name on the same one line
Ex. Line 1 (TeacherA, Student1, Student2, etc)
Line 2 (TeacherB, Student4, Student 8)

I get this result when I created a query
Line 1 (TeacherA, Student1, Student1)
Line 2 (TeacherA, Student2, Student2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top