Totals in a Form

[ssw]

I have a form that has a calculated fields named [goal1], [goal2] etc. which
calculates [hrs] * [Goal#]. When I try to sum a total of these fields no
result. Is there problem with adding calculated fields or is there something
in the advanced properties of the total sum field? Thanks for any help!

 

[Roady [MVP]]

You'll have to be a bit more specific than this. Providing a code sample
would be handy in most cases. Could it be that you are trying to calculate
with text values instead of integers?

Also note that there is a special newsgroup for Outlook forms. You can find
it down the hall called;
outlook.program_forms

 

[Michael Bauer [MVP - Outlook]]

A form field can calculate only values for the one item it displays, it
cannot sum up values from other items.

In order to sum up values from all of the items in a folder, you need to
write a VBS or VBA function.

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?lang=en>


Am Tue, 2 Mar 2010 08:37:02 -0800 schrieb ssw: