By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Addition of mainreport field with subreport field

P: 1
In Ms-Access the mainreport contains subreport having the field with amount column. the main report Amount field con`t add with sub report amount. is there any special command or macro for addition both fields?
Dec 27 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,186
I'm sorry but I don't understand what you need to do here.
Perhaps you could rephrase the question and say particularly what you are trying to do, what you've already tried and where it failed.
Accessing subreports and subforms is fiddly but certainly possible.
Try to include the name of your subreport control (not the defined report that is in there but the control itself).
Dec 30 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
In Ms-Access the mainreport contains subreport having the field with amount column. the main report Amount field con`t add with sub report amount. is there any special command or macro for addition both fields?
You need to sum the subreport amount in the subreport report footer and make a control on the main form equal to

Report![MainReportName]![SubReportName].Report![SumField]

You can then include this field in the sum.

Mary
Jan 1 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.