Summary Fields and Relationships
Table 1: Project Specific Revenue Data is entered into fields each month. 12 fields, one for each month, with another field for 'year', and another field for which 'division' the project is in.
Table 2: Total Revenue is entered into fields each month. 12 fields, one for each month, with another field for 'year', and another field for 'division'. None of these fields are lookup fields from table 1, as the reference in table 1 is project name.
What I want to do: Make a summary report which sums up total of the 12 fields in table 2, and sums up the total of the 12 fields in table 1. To see what % of project revenue makes up total revenue.
I have tried building the summary report in either table, but I cannot get the 'total' of the 12 fields to pull in. (count seems to work though)
I also tried a many to many relationship by building a 3rd table, but still cannot get it to work.
------------------------------
J G1987
------------------------------