0

What is the syntax for operations between fields in different tables?

Dear Collective Wisdom,

I want to perform an arithmetic operation between two different fields. I would think that would be fairly straightforward: [field A] + [field B], or in my particular case, I want to subtract one from the other:[field A] - [field B]. But the fields are in different tables, so [table A.field A] - [table B.field B]. And so far my various guesses haven't yielded the correct formula. Most of my field names use multiple words, for example, "total expenses". Same with my table names, ex. "monthly estimate". 

TIA for any advice on how to format to get what I want.

2 replies

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    Hi Zenmom

     

    When both fields are in the same table tboth values will come from the same record. When they come from different tables you need to be able to say which records they come from. Are they related tables for instance?

     

    Regards John

    • zenmom
    • 2 yrs ago
    • Reported - view

    Not currently, but they could be...  I will take a look at this tomorrow.

Content aside

  • 2 yrs agoLast active
  • 2Replies
  • 204Views