how will i show up the total sum

[accs]

i have a query that has a total sum , my problem is when i create form all the fields in the query is visible in the form but my total sum doesnt show up, but when i view it in query it works properly.


i dont really know what the symbol really is called i just called it total sum
, the E icon in query

thanks really appreciate your help

 

[pr2-eugin]

Did you open the Form in the Design view and use the "Add Existing Fields" menu to add the field that is missing?

 

[accs]

it wasnt showing up.

this is the icon i was talking about i use to total the row filed

in the design view query it is there but in form i dont know how will the running
total sum shows up

thanks for repz,really appreciate the help

 

[accs]

this is the total i want to appear in form









thanks , really appreciate the help

 

[Galaxiom]

AFAIK that grand total value is not available to the form directly from the query.

Add a textbox to the footer of the form and use a ControlSource like:

= Sum([thefieldname])

 

[spikepl]

You can see the totals if you in normal Form view, in access 2007 + , press the Totals icon on the ribbon in the Records section.

 

[accs]

this solves my problem

= Sum([thefieldname])

it is now appreaing in my form


thanks for the repz.

but i have a new problem. i use this same procedure in report
but it doesnt shows up in report view

im getting

error: #error

 

[accs]

i was able to make it appear in report thanks to all who help me



= Sum([Field1]) works]



thnks a lot