<html>
<body>
Thanks.<br><br>
At 4/02/03, you wrote:<br>
<blockquote type=cite class=cite cite>Does sound like you need a
cross-tab query to base your report on - to ensure the correct number of
columns look at Candace Tripp's website for some guidance. She has
a cross tab demo -
<a href="http://www.candace-tripp.com/access_downloads.htm">http://www.candace-tripp.com/access_downloads.htm</a>
or check this one: <a href="http://rogersaccesslibrary.com/TableOfContents.asp">http://rogersaccesslibrary.com/TableOfContents.asp</a><br>
<br>
Hope this helps.<br><br>
<br>
>>> davide@dalyn.co.nz 02/04/03 11:21AM >>><br>
Please don't be offended at this repost but I am getting desperate for <br>
ideas and running out of time (isn't that always the way!)<br><br>
I have a report which I am not sure the simplest/best way to design and am <br>
looking for ideas.<br><br>
I have a table with the following fields: GoalID, Year, Amount, Comments <br>
(Because it is a temporary table created on the fly there is no primary key <br>
field)<br><br>
Each Goal has a record for each year. If there are 5 goals and 10 years <br>
then there would be 50 records.<br><br>
The report is to have the following columns:<br>
Year, Goal 1 Amt, Goal 1 Comment, Goal 2 Amt, Goal 2 Comment , Goal 3 Amt, <br>
Goal 3 Comment, Goal 4 Amt, Goal 4 Comment<br><br>
If there are more than 4 goals then they appear in columns in the next page:<br>
Year, Goal 5 Amt, Goal 5 Comment, Goal 6 Amt, Goal 6 Comment etc<br><br>
It is also possible that each column takes up more than 1 page.<br><br>
I think I am needing a main report with the years in the left hand side and <br>
then a multi column subreport with the actual goal records. However, it is <br>
likely that some of the Comment fields will take more than 1 line but not <br>
necessarily all the comments for a particular year. How can I work out if <br>
I need to leave lines in the left hand column which has the years?<br><br>
Perhaps some type of cross tab report so that each record is just printed <br>
across the page? In this case, how can I ensure that there are the correct <br>
number of columns on the report (there could be anything from 1 to 14 goals <br>
(or 1 to 4 pages). My clients don't want to have the report allow for the <br>
max number of goals and then print out blank pages.<br><br>
Any suggestions?<br><br>
Regards<br><br>
David Emerson<br>
DALYN Software Ltd<br>
25b Cunliffe St, Johnsonville<br>
Wellington, New Zealand<br>
Ph/Fax (877) 456-1205<br>
_______________________________________________<br>
AccessD mailing list<br>
AccessD@databaseadvisors.com<br>
<a href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</a><br>
Website: <a href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</a><br><br>
<br><br>
Regards<br><br>
David Emerson<br>
DALYN Software Ltd<br>
25b Cunliffe St, Johnsonville<br>
Wellington, New Zealand<br>
Ph/Fax (877) 456-1205 <br><br>
_______________________________________________<br>
AccessD mailing list<br>
AccessD@databaseadvisors.com<br>
<a href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</a><br>
Website: <a href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</a></blockquote></body>
</html>