I have two tables. each record in the first table has a related records in the second table. The second table has a summary field used to find the total amount of related records. A report is made to show each record in the first table and the total amount in related records. I want to find the total amount of all records in the first table.
Any help would be appreciated.