Change columnar report to Row

[survivo01]

I have table

Id	Name	Class
25	Fred	ABE
25	Fred	GED
25	Fred	Par
26	James	ABE
26	James	Sub

I would like to create a query, form or report that is by row in data sheet format e.g.

ID	Name	Class	Class	Class	Class
25	Fred	ABE	GED	Par
26	James	ABE	Sub

I can sort of make that happen with crosstab query.


But I end up with

ID	Name	ABE	GED	Par	Sub
25	Fred	1	1	1
26	James	1			1

[June7]

How many classes are there? Review: http://datapigtechnologies.com/flashfiles/crosstab.html

[survivo01]

Nice review helpful but not solution. There could be up to 100 classes. Usually the individual is in only 5 of the hundred classes. When I do a crosstab i get every class a student is enrolled into.
Id Name ABEAM ABEPM 1aIntensive715m 1bIntensive715m 3aRe-entry715m 50aCognitive715m 51aCultural715
25 Fred 1 1 1 1
26 James 1 1
What I want to do is take theis crosstab query and make a report that shows the row for each student without the spaces
ID Name Class Class Class Class Class
25 Fred ABEAM 1aIntensive715m 3aRe-entry715m 51aCultural715
26 James ABEAM 1bIntensive715m
I want to eliminate the empty fields in the report

[June7]

Then will need VBA code.

Review:

http://allenbrowne.com/func-concat.html

http://forums.aspfree.com/microsoft-...ry-322123.html