Hi,

I am trying to solve my problem with calculating salaries in my small company. Have tried to create a database with some tables, forms and queries, but still not sure how to complete the functions I need to get working.

I hope somebody from you guys would tell me how to do it:

I have WORKERS, JOBS, MONEY for JOB. The WORKERS may work on more JOBs a day. On a JOB may work more WORKERS a day. The JOB can be carried out for more than one month. My calculation of salary is made on monthly basis. There is one main CONDITION: by JOBS still not completed, I calculate a fix SALARY PER HOUR multiplied with the sum of hours worked on the JOB. By completed JOB, first I calculate the SALARY PER HOUR by dividing the MONEY for JOB with the total hours worked on the job, than use this value for calculating the total money a particular worker should get for a job and finally I discount all the money I have paid to the worker for a particular job in past months (when the JOB has been qualified as not completed).

Could somebody help me by telling me which TABLES with which ITEMS do I need for this? And maybe to tell me how could I make it working on monthly basis? Maybe I need some Macros for this or some complicated FORMs.

I will appreciate any help. Thanks in advance!