How to use ExecuteSQL

Discussion created by jdd on Jan 31, 2017
Latest reply on Feb 3, 2017 by 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:




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