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

    If statement and report field

    rushy

      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)

      till.png


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


      =IIf([TillMethod]="Cash",[TillAmount],"-")

       

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

       

      How do I go about replicating this in filemaker?