1 Reply Latest reply on May 10, 2010 9:53 AM by philmodjunk

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

    danny_1

      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