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
 
This would be the control source of a text box on the main report.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SynNeed to account for null values in subreports 2
subreport/report total question 5
Return Totals for multiple categories from a subreport 4
Calculate between SubReport and Report 1
Subreport Summary 1
Calculate a sum of subreports in main report 1
Main Report Header is on SubReport 4
Can a Subreport print it's textboxes on the Main report? 3

Back
Top