Hi,

I have a Projects table which holds data on Projects. From the Projects table there is a 1 to many relationship to a Funding Source i.e. a Project can have many funding sources. Each Funding Source has a dollar value it is contributing to the Project.

I want to be able to list each project and the total dollar amount it has. Is it possible to create a formula (or some type of insertable field) that sums the total dollar amount? I can do this with Groups by grouping by Projects and insert the sum of the dollars in the group header but I would like to do this in the details section without using groups.

To put it another way: when I used to create OO (object oriented) reports to achieve the same thing I would create a method that looped over the funding sources and added them then returned the total value. Id then just include the method alongside the project information (if that makes sense).

Thanks for the help.