how do I add/subtract two different fields and store the results in another field?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • scn2
    New Member
    • May 2012
    • 1

    #1

    how do I add/subtract two different fields and store the results in another field?

    Using an Access Table, I have 3 fields and I wish to subtract one from the first one and place the results in the third field.

    field 1 is (Estimated EWW hours) and I wish to subtract (# of Ext Hours) and store the results in a field called Variance EWW Hours.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    It should not be stored. Just calculate it when needed.

    Comment

    Working...