Sum in report Problem

[naungsai]

Dear Friends

I am facing proble with Calculation (sum) in report.

Please check my attached file. I want to run sum of some fields in the report.

Thanks in advance

 

[RainLover]

You have three reports.

Which one is causing you a problem and what have you done so far to solve the problem.

Please explain.

 

[naungsai]

You have three reports.

Which one is causing you a problem and what have you done so far to solve the problem.

Please explain.

Among these 3 reports, "PartI", "DSAsubreport" and "PartIIsubreport". "PartI" is the main and the others are subreports.
If you check the subreports, I tried to find the sum of some varriable which does not work.

Thanks

 

[naungsai]

You have three reports.

Which one is causing you a problem and what have you done so far to solve the problem.

Please explain.

Thanks for your interest.
Among these 3 reports, "PartI", "DSAsubreport" and "PartIIsubreport". "PartI" is the main and the others are subreports.
If you check the subreports, I tried to find the sum of some varriable which does not work.

I have reattached the file which I have modified some variables.

Thanks

 

[RainLover]

In your sub report place your control in the report footer not on the page footer.

 

[RainLover]

I did some more lookings.

The Function "Sum" will not Sum a Control on a Form or a Report. It will only Sum a Field from a Table or Query. So when you use =Sum([rptTerminalAllowed]) this will not work as this is a control on your Report. Sum([TerminalAllowed]) will work because TerminalAllowed is a Field in your Query.

Then to refer to this summed value from the Main report have a look at this link. http://www.mvps.org/access/forms/frm0031.htm

Hope this helps

 

[naungsai]

In your sub report place your control in the report footer not on the page footer.

dEAR RainLover

Thanks for your comment. I have correct it. It works.

 

[RainLover]

Welcome

Glad to hear you got it working.