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]

New problem

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 :)