Calculating the sum of income and expenses in Access?

Question

Microsoft Access

I have an Access table. It stores account changes. They are defined by a sign (that is, greater than or less than 0). It is necessary to calculate separately the expenses and income for the month. There is nothing difficult with the choice of the month, but there were problems with the calculation.

I tried this and that, but either I'm too used to MySQL, or the skis don't go:

SELECT Sum(IIF([Финансы]![Счёт] > 0; `Счёт`; 0)) AS `Доход`, Sum(IIF [Финансы]![Счёт]<0; `Счёт`; 0) AS `Расход` ...

Access does not allow such a query in any way.

Help!

Answer 1

Use the ABS function to remove the "-" sign

Answer 2

In my web version of accounting, I solved the issue using a slightly different algorithm.
The payment has its category, which, in fact, distinguishes an income item from an expense item. category "Food" or "Transportation" is unlikely to be profitable, unless you work in a cafe or in a taxi, in contrast to the category "Salary" or "Income from Grandma's apartment."
Again, the category is a filter for searching / grouping data