RE: cant get fields to add together into another field

From: BruceM (BruceM_at_discussions.microsoft.com)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 04:27:02 -0800

Are you performing the calculation in a text box? Are both fields the same
data type? Remember that you don't want to store calculated values, but
rather have the calculation performed on the fly in a text box or query.

"Joel" wrote:

> Im trying to add numbers from two fields into another field, and i have tried
> the help file and it gives me an error still.
>
> ex: =[Value]+[Cost]
>
> but that wont work for some reason

Relevant Pages

  • Re: Trouble with RANDBETWEEN
    ... Could we say that if we wanted to write out the rule for performing this ... particular type of calculation, that if we wanted to generate a random number ... I am not having much luck with this particular ... >> question in the online help. ...
    (microsoft.public.excel.programming)
  • Int(2.1 / 0.1) returns incorrect value
    ... I am using VB6 when performing a simple calculation that returns ... However, if you dimension those values as variants, the correct value ...
    (microsoft.public.vb.general.discussion)
  • Re: RHS unbound variable
    ... predicate whether Celsius vs Farenheit is unbound, and performing the ... calculation is the proper direction depending on the case: ...
    (comp.lang.prolog)
  • Excel Beginner - Need Help with Looping Operation
    ... Starting at the bottom left (Cell A80 for basic reference purposes), ... need to continue performing the calculuation to the right in that row ... For instance, perform the calculation at A80, ...
    (microsoft.public.excel.programming)
  • Array Formulas in VB
    ... I have a number of ormulas that are performing rather slowly, calculation of ... the workbook takes approximately 2 minutes. ...
    (microsoft.public.excel.programming)