 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008calc values from subreports
Hello. I have a main report named A. Inside I have 3 subreports named 1; 2 and 3. Each subreport as 3 columns. I need that the values of subreport 3 are calculated from subreport 1 and 2. So, my column 1 in Subreport 3 will be the difference between column 1 of subreport 1 and column1 of subreport 2. something looked like: [subreport1].[column1]-[subreport2].[column1] but this is not working for me. Please help me. Regards, Marco It looks like you're seeing the real data as that which is in the subreport columns whereas it's in tables and queries. Is there something that connects the 3 lots of data? If yes, then you can put the data from subreport1 and that from 2 into a query, connect them by the field they have in common and then perform your subtract in the third column of the query. Your 3rd subreport can be based on this latter column. Or do you mean that sub3 should contain the Sum Total of the data in Sub 1 minus the Sum Total of the data in Sub2? Evi > Hello. > [quoted text clipped - 16 lines] > Regards, > Marco Hi. My reports 1 and 2 have not a fixed column. but they load the values from queries. I already make it worked. If I open the reports in single different reports. They are not working when I using it as subreports. Regards, marco > It looks like you're seeing the real data as that which is in the subreport > columns whereas it's in tables and queries. [quoted text clipped - 31 lines] > > Regards, > > Marco |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.