How to combine values of a field together?

[Guest]

I have a simple table of students and the courses that they took - one column
for "Student" and one column for "Course". Each student can take multiple
courses. Is there a way to combine the "Course" field together on an Access
report to show each student on one line?

Example:

Student A BUS-150, ENG-101, MAT-126
Student B PSY-124, ZOO-200

Does Access reports have this option or do I need to write code to read the
recordset and make the combined field?

THANK YOU!

 

[Joan Wild]

'Each student can take multiple courses'. The opposite is true as well.
One course is taken by many students. That's a many to many relationship,
so you might want to reconsider the design.

However, to answer your question, you'll need to write code to get the
effect you want. See
http://www.mvps.org/access/modules/mdl0008.htm

There's also
http://www.mvps.org/access/modules/mdl0004.htm
should you decide to redesign your database.

 

[BruceM]

If you reconsider your design, which was one of the suggestions, it will pay
dividends many times over, and probably take less time than coming up with
code.