Take a look at http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web" for a
couple of suggestions.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> i'm trying to create a way so that if i have multiple rows of data for the
> same person that i can have it format horizontally instead of vertically e.g.
[quoted text clipped - 7 lines]
> m jones x class y class z class
> any help would be appreciated