R
r. howell
I have a form which shows Job Awards
Nested in that is a subformA which shows Trade Awards within the Job
Nested in that is a subformB which shows the Detailed Alternates Awarded
within the Trade Award.
I can make the sum of the detailed alternates show up as the total award to
the trade contractor on subformA. Then I need to make the sum of these trade
contractor awards show up as the total Job Award on the main form.
I have been doing this as in the Northwinds database, by adding a summing
field to the subform footer, and then referencing that field in the main
form. But this process is falling apart at the second level. Is my problem
essentially a calculation on a calculated field? I know that in queries,
this means I need to write another query based on the query with the
calculations.
Any tips on how I should proceed?
Thanks
Nested in that is a subformA which shows Trade Awards within the Job
Nested in that is a subformB which shows the Detailed Alternates Awarded
within the Trade Award.
I can make the sum of the detailed alternates show up as the total award to
the trade contractor on subformA. Then I need to make the sum of these trade
contractor awards show up as the total Job Award on the main form.
I have been doing this as in the Northwinds database, by adding a summing
field to the subform footer, and then referencing that field in the main
form. But this process is falling apart at the second level. Is my problem
essentially a calculation on a calculated field? I know that in queries,
this means I need to write another query based on the query with the
calculations.
Any tips on how I should proceed?
Thanks