>>I have 2 related tables projects and funding that work together in a 1 to many relationship. The funding records contain fields for amount, source, and year. I want to create a report where each project and its funding is displayed together. The project data would be displayed in the first column or block, followed by a column for each year. Something like this:
>>
>>------------------------------------------------------------------------------------------------------
>>project1 name|year1amount1|year2amount1|year3amount1
>>desc |year1amount2|year2amount2|year3amount2
>>etc |year1amount3|year2amount3|year3amount3
>>------------------------------------------------------------------------------------------------------
>>------------------------------------------------------------------------------------------------------
>>project2 name|year1amount1|year2amount1|year3amount1
>>desc |year1amount2|year2amount2|year3amount2
>>etc |year1amount3|year2amount3|year3amount3
>>------------------------------------------------------------------------------------------------------
>
>
>Hi Don.
>
>You can have look at
>
>
www.report-sculptor.com >
>It might offer some alternative ways of doing this report.
>
>
>HTH
>Sergio
How could I forget report-sculptor! Yes Don, check that out.
Cetin