put data into one row

[Guest]

I want to put all of my data into one row so that when I use that data for a
report, it's going to print in one row. What's the best way to do this?
The queries I have so far(using the studnent and class tables) would have my
data printing out vertically:
STudent Name:
class: History
class: Science 101
class: Math 10A
etc....
How do I get it to print like this:
Student:a: History 101 Science 101 Math 10A

 

[John Vinson]

I want to put all of my data into one row so that when I use that data for a
report, it's going to print in one row. What's the best way to do this?
The queries I have so far(using the studnent and class tables) would have my
data printing out vertically:
STudent Name:
class: History
class: Science 101
class: Math 10A
etc....
How do I get it to print like this:
Student:a: History 101 Science 101 Math 10A

Try a Crosstab query; or see the VBA code at

http://www.mvps.org/access/modules/mdl0004.htm


John W. Vinson[MVP]

 

[Guest]

Thanks John, I'll check the VBA code out.

Try a Crosstab query; or see the VBA code at

http://www.mvps.org/access/modules/mdl0004.htm


John W. Vinson[MVP]