13 Replies Latest reply on Nov 16, 2009 2:17 PM by benjibear

    Calculating sums from selective entries

    benjibear

      Title

      Calculating sums from selective entries

      Post

      Hi,

      I am trying to build a simple accounting database.

      I have expenses listed in a table with fields for date, supplier, item, category, amount etc.

      I would like to select all entries of a certain category (e.g. Travel) and sum up the corresponding amounts

      in a new field, to indicate the total travel expenses.

      I am not sure how to formulate the calculation field.

       

      I would greatly appreciate some advice.

       

      Benjamin