AnsweredAssumed Answered

company expense data base: how to add the expenses of one employ

Question asked by danny_1 on May 9, 2010
Latest reply on May 10, 2010 by philmodjunk

Title

company expense data base: how to add the expenses of one employ

Post

Hi All,

 

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!

 

best,

 

dan

 

Outcomes