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:
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?