I have an application that tracks office space (measured in sq ft.) requirements for PT and FT employees by Department.
I am trying to generate a form that shows the Department info. on the main form and then the PT employees and FT employees on 2 subforms.
I want to add the total square foot requirements for the Part-Timers to the square foot requirements for the Full-Timers.
Unfortunately, I get a #name? error message when I use the following formula:
= Forms![QDeptPTProjected subform]![Sum Of PTSF] + Forms![QDeptFTProjected subform]![Sum Of FTSF]
note: Sum of PTSF and Sum of FTSF are calculated controls on the subforms
When I use the following formula, I get correct totals for Department 1 and then a #error? message for all subsequent departments.
=[Child52].[Form]![Sum Of PTSF]+[Child54].[Form]![Sum Of FTSF]
Any idea what I'm doing wrong here. Thanks.
I am trying to generate a form that shows the Department info. on the main form and then the PT employees and FT employees on 2 subforms.
I want to add the total square foot requirements for the Part-Timers to the square foot requirements for the Full-Timers.
Unfortunately, I get a #name? error message when I use the following formula:
= Forms![QDeptPTProjected subform]![Sum Of PTSF] + Forms![QDeptFTProjected subform]![Sum Of FTSF]
note: Sum of PTSF and Sum of FTSF are calculated controls on the subforms
When I use the following formula, I get correct totals for Department 1 and then a #error? message for all subsequent departments.
=[Child52].[Form]![Sum Of PTSF]+[Child54].[Form]![Sum Of FTSF]
Any idea what I'm doing wrong here. Thanks.
