how to add the amount of a column (sum) per page in access

[yayanpuji]

I have a problem when trying to add some sums in every page of my report. The default "Total" menu in Design tab, is only adding total sum in the end of the report, there is no option to add it in every page.

I have looked at "Placing sums in header/footer report" in http://office.microsoft.com/en-001/a...001122444.aspx,
but still did not understand the code txtPageSum = txtPageSum + ExtendedPrice, txtPageQuantity = txtPageQuantity + Quantity means in referring to the "extendedPrice" and "quantity".
Anyone could help me with this VBA-solving in Placing sums in footer report? Or does anybody have the other easier alternative?

[June7]

txtPageSum and txtPageQuantity are names of textboxes on the report. ExtendedPrice and Quantity are fields from the report RecordSource query. Modify references as appropriate for your db. I very much doubt there is any alternative method.

[yayanpuji]

txtPageSum and txtPageQuantity are names of textboxes on the report. ExtendedPrice and Quantity are fields from the report RecordSource query. Modify references as appropriate for your db. I very much doubt there is any alternative method.

please see my work. I would like to place sum in footer. There is the unbound textbox supposedly summing all the "Jumlah". What is the appropriate VB coding?

[June7]

Don't understand your confusion. Setup looks correct. Replace the field names in the code with your field names. Replace textbox names. Modify the code for as many 'sums' as you want.

If you have modified code and it errors, what is the error? Post your attempted code for analysis.

[yayanpuji]

Don't understand your confusion. Setup looks correct. Replace the field names in the code with your field names. Replace textbox names. Modify the code for as many 'sums' as you want.

If you have modified code and it errors, what is the error? Post your attempted code for analysis.

I have modified the code as it is shown in this attachment:


but when i print previewed, the sum "Jumlah" is not in the footer.

Is there anything I missed?

[yayanpuji]

here is my db, the report is in the "coba_Query" Report. There is no confidential data, so I didn't edit anything.
please fix the print sum footer "Jumlah" section in the Unbound textbox.

[June7]

Must run report in PrintPreview or direct to printer. ReportView will not work.

[yayanpuji]

Have done what you said. Still no result.

[June7]

The page and report footer sums all show for me.

The textbox isn't wide enough to display the full value of Jumlah sum in the report footer.

Select all the controls on the report, right click > Layout > Remove. Now you can move and resize each control independently.

[yayanpuji]

Thank you.Turns out the problem is on the"Security Warning" (Certain content in the database has been disabled), that needs to be click "Options..." and "Enable this content".The VB is deemed as a security warning. And when this notification is cleared, then the VB can work well.