sum on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one field in a subreport and one field in a main report. I just want the total of them together on the main report. Do I need to do a query first?
Thanks
 
A query is one method. The other is to use an expression in the main report
that references the control name from the subreport and adds it to a control
on the main report. The syntax might be:
=IIf(srptA.Report.HasData, srptA.Report.txtA, 0) + txtB
--
Duane Hookom
MS Access MVP


Jenny said:
I have one field in a subreport and one field in a main report. I just
Click to expand...
want the total of them together on the main report. Do I need to do a query
first?
 
Duane where do I put that code in the control source of the Repor

----- Duane Hookom wrote: ----

A query is one method. The other is to use an expression in the main repor
that references the control name from the subreport and adds it to a contro
on the main report. The syntax might be
=IIf(srptA.Report.HasData, srptA.Report.txtA, 0) + txt
--
Duane Hooko
MS Access MV


Jenny said:
I have one field in a subreport and one field in a main report. I jus
Click to expand...
want the total of them together on the main report. Do I need to do a quer
first
 
Back
Top