Sub Report Totals

[berkBW]

I have a report that when added to the main report as a sub report, I get one
extra count in my total. So the report totals correctly by itself but when
used as a sub report I get one extra count.

 

[Duane Hookom]

It would help if you told us how the count was calculated. Is it a text box
with a control source like:
=Count(*)

 

[berkBW]

With in the details section of the report I have a number of text boxes that
have Iif statements in them that are set to calculate the totals. Then in the
footer section I reffer to those text boxes =[txtTotalDI] to display the
totals.

 

[Duane Hookom]

I would use an expression that only references fields and calculations from
the report's record source, not values of controls from other sections of the
report.
--
Duane Hookom
Microsoft Access MVP

With in the details section of the report I have a number of text boxes that
have Iif statements in them that are set to calculate the totals. Then in the
footer section I reffer to those text boxes =[txtTotalDI] to display the
totals.

It would help if you told us how the count was calculated. Is it a text box
with a control source like:
=Count(*)

 

[berkBW]

Well my Iff statements references the query that the report uses, to get it's
totals. If that is what you mean. Again the report works fine until you put
it in the main report. Then their is only one "total" that has one extra
value.

I would use an expression that only references fields and calculations from
the report's record source, not values of controls from other sections of the
report.
--
Duane Hookom
Microsoft Access MVP

With in the details section of the report I have a number of text boxes that
have Iif statements in them that are set to calculate the totals. Then in the
footer section I reffer to those text boxes =[txtTotalDI] to display the
totals.

It would help if you told us how the count was calculated. Is it a text box
with a control source like:
=Count(*)

--
Duane Hookom
Microsoft Access MVP


:

I have a report that when added to the main report as a sub report, I get one
extra count in my total. So the report totals correctly by itself but when
used as a sub report I get one extra count.

 

[Duane Hookom]

Your IIf() statements in one section refer to fields but you also stated
"Then in the
footer section I reffer to those text boxes". I would search for a method
that doesn't reference "controls" from other sections.
--
Duane Hookom
Microsoft Access MVP

Well my Iff statements references the query that the report uses, to get it's
totals. If that is what you mean. Again the report works fine until you put
it in the main report. Then their is only one "total" that has one extra
value.

I would use an expression that only references fields and calculations from
the report's record source, not values of controls from other sections of the
report.
--
Duane Hookom
Microsoft Access MVP

With in the details section of the report I have a number of text boxes that
have Iif statements in them that are set to calculate the totals. Then in the
footer section I reffer to those text boxes =[txtTotalDI] to display the
totals.

:

It would help if you told us how the count was calculated. Is it a text box
with a control source like:
=Count(*)

--
Duane Hookom
Microsoft Access MVP


:

I have a report that when added to the main report as a sub report, I get one
extra count in my total. So the report totals correctly by itself but when
used as a sub report I get one extra count.