Everything on One Line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that displays a users picks in a sports pool. I have a field
called Name another field called Pick and a field called Golfers. Each Player
gets to have 4 golfers for their pick. Right no3w the report looks like this

Name PickNo Golfer

Tom 1 Tiger Woods
Tom Watson
Jim Furyk
David Duval

This takes up alot of space when you try to create a report and print it. Is
there any way I can have everything on one line so I can post and print this
much easier.

I would like it to look like below
Name Pick No Golfers

Tom 1 Tiger Woods Tom Watson Jim Furyk David Duval

Bob 2 Arnold Palmer Bobbie Jones Fred Couples Tiger Woods

Any help would be appreciated

Regards

Chris
 
You could create a group on the user, make the detail invisable, create a
group footer (on the user) and then in code behind the detail section store
the golfers into a string variable. When the group footer prints fill in the
fields using vba and the information you have stored up. Once you have them
printed then you clear the variables ands start accumulating again.

Dale
 
Thanks But I have no clue on how to do that. Is the code a line in the contro
source or is it a reference to a module. any Help would be appreciated. Than
you

chris
 
Back
Top