AnsweredAssumed Answered

If statement and report field

Question asked by rushy on Dec 9, 2015
Latest reply on Dec 10, 2015 by 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?

Outcomes