Problem with Subreport Totaling

I

IreneJ

Hello,

I have a main report with four subreports. Each one of
the subreports has its total shown on the main report and
then all four are totalled together.

My challenge is with one of the subreports. When you run
the subreport 'Volunteer' by itself it reports a total of
$252.00 in the field that is named
VGAmounttoContractorTotal, but the box that has that name
on the main report shows a total of $162.00. I have
tried everything to see if I had missed something but
can't see it. All four of the subreports have the same
statement in them, it is:
=IIf(Volunteer.Report.HasData,Volunteer.Report!
VGAmounttoContractorTotal,0)

Any help gratefully accepted. Thanks so much,
IEJ
 
D

Duane Hookom

I expect you have a Link Master/Child set on the subreport control that
limits the results in the subreport when it is run on the main report.
 
I

IreneJ

Thank you, actually I have all the four subreports on the
main report and there is no link master/child on any of
them. Each subreport runs off a query that has criteria
lines for a date from frmPrintDialogueBox for
BeginningDate and EndingDate as well as CrewID. All the
subreports are in the Date Footer on the main report with
the subtotals showing under them. Is there always
supposed to be a link master/child on all subreports?

IEJ
 
D

Duane Hookom

Setting the Link Master/Child isn't always required. I would check the
control references again.
 
I

IreneJ

Thank you, can you elaborate a bit, when you say control
references, do you mean the references in the Module? Or
something else.

Thanks again for your help.
IEJ
 
D

Duane Hookom

I meant only the control names. You shouldn't have to check references in a
module. I assume you don't have any event code in your report(s).
 
Top