company expense data base: how to add the expenses of one employ
I am new to File Maker. I have wanted to upgrade our system from an excel spreadsheet, as it was becoming too labour intensive.
I have a table with expenses all our employs. (all 3!) i want to write a script, (or something else?) that calculates the totals of each.
The table looks like
Employ, expense, amount, detail,
i want to program something that go through the entire table doing
if employ = "Dan" then sum "amount"
How do i do this?
thank you for any help!