Re: performing calculations in the table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tony P (anonymous_at_discussions.microsoft.com)
Date: 02/08/04 

Date: Sun, 8 Feb 2004 01:41:31 -0800

Thank you for help. I have it working.

To update the fields I have added a short procedure which
is executed on exit from the data entry fields.

Tony

>-----Original Message-----
>Hi Tony
>
>You don't actually need any code for this the answer is
in the formatting you
>apply to your Formula field, the following will do what
you want:
>
> { = 3+5 \# ",0;-,0;" }
>
>The "3+5" is the formula, you need to replace this with
your calculation. The
>key bit is:
> \# ",0;-,0;"
>
>The part before the first semicolon is the postive number
formatting, the
>part between the two semicolons is the negative number
format and the part
>after the last semicolon is the zero number format, which
in this case is
>nothing!
>
>For more details check out WOrds online help on "Numeric
Picture (\#) field
>switch"
>
>HTH + Cheers - Peter
>
>
>"Tony P" <anonymous@discussions.microsoft.com> wrote in
news:c67901c3edcc
>$96f2c630$a401280a@phx.gbl:
>
>> I am creating a form template with a table where user
is
>> going to enter values into form number fields. I want
to
>> calculate sum for each row. It is working if I use
>> Calculation field, but it displays 0 when there are not
>> entries. I am looking for solution which will display
>> values when sum is greater than 0 and will be blank for
>> sum equal 0. Is it possible to modify the formula in
the
>> calculation field ? I was trying to create macro to be
>> executed on exit from the fields but I can not figure
out
>> how to calculate the sum which will be entered into the
>> sum cell in the table. How I can solve my problem ???
>> Thanks for suggestion.
>>
>> Tony
>>
>
>.
>

Relevant Pages

  • Re: decimal values create inequality
    ... the Round function every time I want to compare the sum of components ... that are entered from a source document, ... Since the above formatting displays 25 for both ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Conditional Formatting And Running Sums
    ... > I have a report in which I am using a running sum to display the total ... formatting applied to it in the detail section. ...
    (microsoft.public.access.reports)
  • Re: infinity
    ... >> those are also threshold values. ... > Tony is basically claiming that "finite" numbers exist ... the sum of all finite numbers. ...
    (sci.math)
  • Re: decimal values create inequality
    ... David Biddulph ... entered from a source document, while D1 is the Total listed on the same ... There are random times whereby the sum of A1:A30 results in a number such ... Since the above formatting displays 25 for both values, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Conditional Formatting And Running Sums
    ... Formatting -- that'll work fine in reports. ... > I have a report in which I am using a running sum to display the total ...
    (microsoft.public.access.reports)