Data from many records into one Memofield?

[Diane99]

Hi there,
I have 2 tables:
tbl_Class with fields ClassID,ClassName,ClassInfo
tbl_Students with fields StudentID, ClassID, StudentName

The relationship is one(one class) to many (many students in one class)

What I need is to get all the names of the students in the ClassInfo Memofield. The names need to be seperated with <p></p> html tags.

Can this be done with a query?

Thanks!

Diane

[orange]

What about 1 student can take many Classes?
Maybe you have a many to many, that is the norm with Students and Classes, where you have a junction table

tblStudentClass
StudentClassId PK
StudentId FK ( StudentId in tblStudents)
ClassId FK ( ClassId in tblClasses)

ClassId would not be in the tblStudents

[Diane99]

Thanks for your reply orange.No, in this case a student can only be in 1 class.Diane