1 2 Previous Next 18 Replies Latest reply on Feb 3, 2017 12:41 AM by jdd

    How to use ExecuteSQL

    jdd

      I want to create 3 tables in File Maker. Tab1 where I am to enter income records, Tab2 to enter expense records and Tab3 to calculate Balance per date. Here is an example to illustrate my ideas:

      Tab1.png

       

      Tab2.png

      And here is how I intended to calculate the balance for each record in Tab3:

       

      Calculations in Tab3.png

      I get no syntax errors on my ExecuteSQL statements above, but as shown in the result table Tab3 below,
      there is something wrong in my solution. What am I doing wrong?

       

      Tab3.png

       

      Kindly regards

      Dennis Davidsson

        1 2 Previous Next