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

    How to use ExecuteSQL


      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:




      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?




      Kindly regards

      Dennis Davidsson

        1 2 Previous Next