put data into one row

T

trevi

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
 
J

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
Click to expand...

Try a Crosstab query; or see the VBA code at

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


John W. Vinson[MVP]
 
Top