sum problem

[ghost]

Hi,
I have a report for present an employee tasks. At the footer I put a text
box for sum the No of tasks. But the text box gets error. I need to sum all
tasks at that text box
Can any body help me?

 

[Duane Hookom]

What is the control source of the text box?
Did you mistakenly put the text box in the Page Footer rather than a group
or report footer?

 

[ghost]

thank you,
the problem was with the page footer.
Can you explain the purpose of the page footer & header please?
you help is highly appreciated

 

[Duane Hookom]

Page headers and footers are for displaying information you want at the top
or bottom of each page. Generally, these sections will not contain any text
boxes bound to your data. The types of values displayed in Page Sections are:
Page numbering
Current date and/or time
Column heading labels
Report title
There are some knowledgebase articles on summarizing data values in Page
Sections but this takes some work.

 

[ghost]

Thank you for your cooperation Mr. Duane
One more question. Regarding the text box of the sum function, can I sore or
save the result in specific record. If yes, please clarify
your help is highly appreciated.
thx

 

[Duane Hookom]

I assume you meant to "store or save" the result. I would not attempt to
perform any record updating from a report. I usually recommend against
storing calculated values.

If you meant something else, please clarify.

 

[ghost]

hi,
yes this what i meant, i want to save the value for a form to show all
employees tasks .
thx.

 

[Duane Hookom]

Don't store the value just because you want to display it on a form.
Calculate the values with a totals query or whatever.

 

[ghost]

hi,
Hi,
I have a text box for sum a group of text box in sub form. When I run the
form, it works. But when I run the form using another form†run the form from
other form by using a button†the sum text box does not work. Can you help me
please?
thx!