jdd

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:

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

Outcomes