Hello everyone,
I have relatively simple problem, but I am just a basic user of Access. I need to calculate sums based on several criteria. My database is one sheet in Excel, it is divided into few columns. (year, place, partner, amount) All what I need is to calculate sum of all amounts for a specific year at one specific place for all the partners. In addition one column denotes whether it should be added to or subtracted from a final amount. So I need to place a condition, whether it is plus or minus based description in a single word (sold/bought). I will appreciate any help.
Thank you in advance.