Calculating sums from selective entries
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.