How to put Total in pagefooter in report (1 Viewer)

[phatus]

hi attached here is the sample of my dbase consist of the following

Table> total here is i just click the auto sum in the ribbon
Query>Source Table :total here i just click the auto sum in the ribbon
Report>Source Query
Form>for searching records

here my dbase work:

in the form consist of 5 combox and 3 button
Clear
Search query
and print preview

what i want to appear when i click print preview is the total in every district i search must appear in the pagefooter of the report but i cant put it in the report when i add a field from the query the Total is not there...

hope it clear.. if you have question for clarification pls ask...

thank you

 

[apr pillai]

You have not given any expression in the Page Footer to show what you were trying to do.

If you want the Total of Fields Grade I-VI and Pre-School values in the Page Footer of the Report you can write the following Expression in a Text Box:

=[Grade I-VI]+[Pre-School]

You cannot use the funtions like SUM(), AVG() in the Page Footer, these will work only in Report Header/Footer Section.

 

[vbaInet]

You cannot use the funtions like SUM(), AVG() in the Page Footer, these will work only in Report Header/Footer Section.

... you can get the total in code by having a variable in the Print event of the Detail section to add up the values and then return the value in the Print event of the Page Footer section. Reset the variable (to 0) in the Page Header section's Print event too.