using sum function

[Aussie John]

I have a portal with a series of records - each is a company with an amount paid.

Some records duplicate the company but with a different amounts.

I'd like to get a total for each company. I've made a relationship between the companies and tried the Sum(field) function but without success.

eg

field1= company

field2 = amount

field3=Sum(table1amount:amount)

relationship field1(Table1amount)<---->field1(table1)<-----> (other table and field)

I know I can do this with subsummaries but would like the result to be dynamic. Thanks for any help

Edited November 2, 2006 by Guest

[Ender]

If you had a Company table, you could use a Sum(Payment::Amount) calc to show the total for each Company.