>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