Combining Text Records

[samevans35]

I have a table in my database with a many-many relationship. One field being Pupil ID, one being Subject ID, and then 12 other fields each reffering to a different type of grade i.e. Attainment, Attitude, Punctuality etc. i.e. in this table there are many records for each pupil referring to his grades in each subject.
To mail merge the table I need to have all the grades/subjects for one pupil in one record (or do i?) this is so that I can have all the grades for one pupil on one page. A report is unsuitable for me because I need to use the wordprocessing capabilities of word. Is there a way i can group all the records for one pupil into one or do I have to do something else?
Please help,
Sam

 

[bosun]

I did a similar thing when building a form letter.

My customer table had the following fields:
FName, LName, Address, City, State, Zip

In query design view for the query on which my letter was based, I entered the following into the Field box:

Address: [tblCust]![FName] & " " & [tblCust]![LName] & "
" [tblCust]![Address]& "
" [tblCust]![City] & ", " & [tblCust]![State]] & " " & [tblCust]![Zip]

The address field created by that query looked like this

FName LName
Address
City, State Zip

TIP if you right click on the feild box in the query you can build this in the expression builder... much easier than typing it all out.

Let me know if that helps.