>>>Nothing,
>>>Remove aggregate functions and GROUP BY and you will see what happened.
>>>Some records will be doubled just becuase you added another table.
>>>Maybe you have more than one record for TipID and Fundtype = 'RTA' in TIP_ApprovedFunding
>>
>>Borislav - You are right. The relationships are:
>>RTA_Element is parent
>>TIP_Projects is child
>>TIP_ApprovedFunding is child of TIP_Projects
>>TIP_Ledger is child of TIP_Projects
>>
>>Is there no solution to putting this together? My original code had one of the columns derived by a second select but I can't seem to make that work either.
>
>Take a look at this blog post explaining the problem and a solution
>
>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/aggregates-with-multiple-tables

:o)
I always try to stick to 2000 syntax (just because of 3 clients)
They definitely don't want to upgrade.