Hi Every body i am new to Access and i am designing a payroll system for my company.
I have created a Table with EMP Id,Name,Basic Pay,Total Working Days,Actual Work Days,Earned Salary,OT days,OT Hrs,OT Pay.........
Now i have created a form with all the above fields.and calculated the earned salary from the control source where Earned Salary= Basic pay / Total Working Days*Actual Work Days and OT Pay =[Basic Pay/Total Work Days/8]*150%*OT Hrs.
Now my problem is i am not able to populate the fields in the table and can you please help me for the OT Pay calculation also.I will be very much thankful if anybody can help me.
I have created a Table with EMP Id,Name,Basic Pay,Total Working Days,Actual Work Days,Earned Salary,OT days,OT Hrs,OT Pay.........
Now i have created a form with all the above fields.and calculated the earned salary from the control source where Earned Salary= Basic pay / Total Working Days*Actual Work Days and OT Pay =[Basic Pay/Total Work Days/8]*150%*OT Hrs.
Now my problem is i am not able to populate the fields in the table and can you please help me for the OT Pay calculation also.I will be very much thankful if anybody can help me.