Hi guys.

I created a small database for an association's accounting, which needs to track expenses and income, with a progressive calculation.

I created a single field, for both income and expenses, but this requires the operator to insert a minus sign (-) for expenses, otherwise they add up.

Alternatively, I created a script that, if the "EXPENSE" option is selected in a field, inserts a minus sign in the Amount field.

Do you think I'm doing something wrong and should I use a more "elegant" method?

Like inserting two fields, one for income and one for expenses, or something else? 🙂

Thanks.

Geppino

If you cannot rely on users to enter a negative amount for expenses then let them enter a positive amount for both and use a calculation field along the lines of:

If ( Type = "expense" ; -EnteredAmount ; EnteredAmount )