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!
I beileve a summary report can be designed to do what you want.
Here's a link to a simple tutorial on setting up summary reports that you may find useful:
Creating Filemaker Pro summary reports--Tutorial