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

Sum the Subreports

P: 9
Hi everyone,

I am using Access 2003.

My report encompasses probably around 9-10 subreports (source=crosstabs). All these crosstabs are generated from the same main table. The reason, just in case someone asks, is that there are like 10 value fields need to be summed individually by year. A Crosstab only allows 1 value field. All the subreports have linked by the CustomerID.

I need to sum some of the subreports together, say 6 out of the 10. Anyone know how to do this? Do I need to create an another subreport just for the sum of the subreports?


Thanks in advance.
Dec 27 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi everyone,

I am using Access 2003.

My report encompasses probably around 9-10 subreports (source=crosstabs). All these crosstabs are generated from the same main table. The reason, just in case someone asks, is that there are like 10 value fields need to be summed individually by year. A Crosstab only allows 1 value field. All the subreports have linked by the CustomerID.

I need to sum some of the subreports together, say 6 out of the 10. Anyone know how to do this? Do I need to create an another subreport just for the sum of the subreports?


Thanks in advance.
Probably, however you could try using a group footer and see if this will work

Mary
Jan 1 '07 #2

Post your reply

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