Your question is confusing and not very well explained, however, assuming that what you want is this:
1) To record the basic (normal) salary for an employee
2) Record extra income for additional work
3) Record expenses to be removed from total salary (bunish?)
4) Record extra income for 'comm' work, (whatever that is, commission?)
Then you would be better of having a table for employees and a single table for income items. Each income item would have a category (from a third table), 'addition_work', 'bunish', 'comm', 'salary' etc.
Your total income would then be a query not a table using SUM(field from income items table) and using Group By for various reporting effects.
A period (e.g. month, week) etc. would seem sensible also.
Then have a look at
this[
^].
M
Submit an article or tip