Printing Report Problem!

[slenish]

Hi,

I am having a problem when I go to print a report from my query. I want to print peoples names in my query that is in the names column but when i try to print them it keeps reprinting the name title box for each name is there a way to stop this so it only prints the title once and then just lists all the names??

So for example what is happening is it prints.....Name.....Aaron......Name.....Adam etc..

But I want it to just print,
Name.....Aaron.......Adam.....Barry....etc.

Any help would be great thanks :)

[hedges98]

Put the Name label in the page header and then the Name textbox in the detail.

[slenish]

I am having another problem now where when I got to print it doubles some the information. So for example I have it print name1 and then name2 but it does it twice one after each other. Any idea why it would do that??

[slenish]

Thanks for the help that worked great! Now I have another problem. I have 4 seperate name boxes that I need to print information from but I dont want to have all 4 boxes in the report lay out. I know that I can use one box and have it pull all the data but I can only figure out how to code it so it will keep them going in a straight line. Is there any way to change the code so they will print under each other.

For example NameBox..........(code)=[NameOne]&","&[NameTwo] this way prints two names but they are next to each other how would i change the "," part so it will drop the second name under the first name?

Thanks in advance :)