I've posted this before and someone suggested using the move layout property, but I haven't figured out how to use that property. Help is not much help!<br><br>I need to have a report that is formatted as such:<br><br>Joe Smith 1997,1998,1999<br>Mary Brown 1983, 1987<br><br>instead of:<br><br>Joe Smith 1997<br> 1998<br> 1999<br>Mary Brown 1983<br> 1987 <br><br>Each year is a separate record in a table.<br><br>If movelayout won't accomplish this, is there a way to write code to have all the years for a particular id number combined into one field to be used on the report?<br><br>Thanks!! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Move Layout property
- Thread starter jgarnick
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
I'm not sure I'm getting the concept here, can you give a more specific table layout? How exactly does the id number relate to the years? Is it two tables that relate to one another or one single table containing all of the info? If you can give me more maybe I can help...good luck. =]
- Thread starter
- #3
Thanks for responding. The report is based on two tables that are related by id number. The relationship is a one to many. Table A has the name and table B has all the years of residencies. I need my report to list each person's years of residencies. Since each year of residency is a separate record in Table B, there can be multiple detail lines per person, but the report prints them line by line. I would like the years of residency side by side to not waste so much paper.<br><br>Under the Onformat property for the year of residency field in the detail section, I set the Movelayout property to False in code. I also set the Nextrecord property to True. It causes the years to overlap one another. I don't know how to get the years to print side by side separated by a comma preferrably.<br><br>The other way I thought of doing it would be to run through table B and gather all the years of residency by id number into another field. I'm not sure if that makes sense to do it that way or even how!<br><br>Thanks for helping me! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>
- Thread starter
- #4
Guest_imported
New member
- Jan 1, 1970
- 0
Not sure it is exactly what you want but I have been able to make reports look similar to what you are asking for by using colums on a report. If you click on page set up and click on the colums tab then click on the go across and then down check box. Based on your groupings and such you can come pretty close to the look you want.
- Thread starter
- #6
Thanks glo4, but I couldn't get it to work using columns. <br><br>Any other ideas anyone??? I know there has got to be a way!<br> <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
