Bring a field from one table to another and then calculate with it
I’m trying to figure something out, and no matter how hard I try, I keep getting no results.
In table “Events” I have the field “Service Costs”
I want to see the summary total of “Service Costs” on the table “Expenses”
I also want to add the amount of the “Service Costs” field from “Events” to the amount of the “Reimbursements” field (also from “Events”) but all to shown in the “Expenses” table.
I’m really at a loss at how to do this, maybe someone can explain it slightly differently as I’ve read so many things and I’m still just as lost as ever. Thank you so so much