5 Replies Latest reply on Dec 10, 2015 1:25 AM by rushy

    If statement and report field


      Im converting an Access database with VBA to filemaker in order to make it accessible on mac.

      The original database that I created is very simple and i have almost fully completed the migration. However when it comes to reporting here is where I have encountered a problem.

      The current database is used to create records for transactions much like a till. With each record being assigned a method (cash, card or cheque)

      The report is used to print a daily record of how much money has come in via each method (attached a screenshot below)


      Currently in the access record I use the following code to obtain the data from the tables.



      This coding allows the report to show the amount instead of the actual method used.


      How do I go about replicating this in filemaker?