Is there a way to make an automatic calculation in a table?
This is why I need it:
I have a table named "Invoices." The columns are Invoice number, Client, Concept, and SubTotal.
BUT.... SOMETIMES there will be a sales tax included, SOMETIMES NOT. So I need two extra columns: One YES/NO labeled "Sales TAX" and another that will calculate a 16% sales tax IF the previous columned is marked "YES." If not, then the value will be 0.
I need to store this value in the table, because it doesn't always apply.
The Total (Subtotal+Sales TAX) will not be entered directly on the table, but displayed in a form/report