<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV>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></DIV>
<DIV> </DIV>
<DIV>Hope this helps.</DIV>
<DIV><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><BR></DIV></BODY></HTML>