Re: performing calculations in the table

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

From: Peter Hewett (Nospam_at_xtra.co.nz)
Date: 02/08/04 

Date: Sat, 07 Feb 2004 22:42:35 -0800

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: performing calculations in the table
    ... is executed on exit from the data entry fields. ... >Hi Tony ... in the formatting you ... >> calculate sum for each row. ...
    (microsoft.public.word.vba.general)
  • 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)