report printing next data in column form 1

[tim4085]

Hello I am thinking others must do this, but I am new to access. I have a table that has two fields. username & software name. I wish to print a report that is grouped on the user name, but under details list the software
name in column form so it would look something like this:

Joe blow
_________
aaaaa bbbbb ccccc ddddd eeeee
fffff ggggg hhhhh iiiii jjjjj

john smith
__________
aaaaa bbbbb ccccc ddddd eeeee
fffff ggggg hhhhh iiiii jjjjj


basically what I get now is

joe blow
________
aaaaa
bbbbb
ccccc
ddddd
eeeee
fffff
ggggg
hhhhh
iiiii
jjjjj


Thanks in advance for any help you can send my way.

 

[dhookom]

I would create a report of just the user names. Then create a multi-column subreport of the software. Add the subreport to the main report and set the Link Master/Child properties to the UserName.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[batteam]

What you need to do is, in report design view, got to |File|PageSetup| then in the PageSetup dialogue box, choose the Columns tab and go from there. You will probably have to experiment a little to get the spacing and column numbers that look good for you.

Good luck.

 

[tim4085]

batteam Thank you ever so much. That was it. that makes it so nice and easy. I appreciate it.


Tim