>>>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.
Thks Cetin :)
See PM.