S
Susie
I have a report that has expense information on the main
report and a sub-report with employee information. I need
a report total by employee number for expenses. The way
the database is set up, I have no choice but to use the
sub-report. Since the employee number is on the sub-
report and the expense amounts are on the main report, is
there a way to have report totals for expenses by employee
number on the main report? I tried to use the following
in a text box in the report footer: (Control Source) =Sum
(IIf([CAV_Sub_SalesRep]![position] Like "pcr*",
[ACTIVITY_EXPENSE],0)) Is there a possibility this will
work, or do I have a syntax error. Thank you in advance
for your help.
report and a sub-report with employee information. I need
a report total by employee number for expenses. The way
the database is set up, I have no choice but to use the
sub-report. Since the employee number is on the sub-
report and the expense amounts are on the main report, is
there a way to have report totals for expenses by employee
number on the main report? I tried to use the following
in a text box in the report footer: (Control Source) =Sum
(IIf([CAV_Sub_SalesRep]![position] Like "pcr*",
[ACTIVITY_EXPENSE],0)) Is there a possibility this will
work, or do I have a syntax error. Thank you in advance
for your help.