I am writing a report and as a beginer, I want to list course programmes for new appliants in rows and its currently in columns> For instance, I have say

Name Subject
Frank Amoko CP2A
Frank Amoko ST2A
Frank Amoko GT1R
Evely Dow BB2A
Evely Dow MU1S

and want the report to look like
Name Subject 1 Subject 2 Subject 3
Frank Amoko CP2A ST2A GT1R
Evely Dow BB2A MU1S

Any help on this

Build the report using the wizard, and then group on the student name. Then add columns to the report. I have seen it done but have not done it. You can also just have:

Frank Amoko
CP2A
ST2A
GT1R

Evely Dow
BB2A
MU1S

Does that help? If you want to collapse this into a temporary table, it will take some coding.

Who has a more elegant solution?


mmcdonal

Azambee,
What does your table structure look like? How many courses could each applicant be enrolled in?

As mmcdonal said, with a little bit of coding, you could create a temp table, that recreates itself each time you run the report.

The code itself isn't difficult.

HTH,

Kevin

dartcoach

Hi mmcdonal, My current report is in the format you have described but they want each student's courses to be on the same row. So for Frank Amoko for example his should read as;
Student Name Subject1 Subject2 subject3
Frank Amoko CP2A ST2A GT1R
Evely Dow BB2A MU1S

Each student could enrol an a maximum of 7 courses and any point in time. If I want to use code how can I do it. I am just a beginner. I have read books but not getting the correct code to do it. Any ideas.
etc

The structure of the table is like this:
StudentID, Student Name, DOB, Subjects

The new Structure will look like this;
StudentID, Student Name, DOB, Subject1; Subject2, Subject3 ....Subject7

I tried coding it but because I am new to VBA its not working. Any help with the code??