Hi
I am a beginner to MS Access and tried creating few tables and queries.
We have Salary details and OT details and the final output is Netsalary generated in a new table named as "NetSalary"
In the given data OT amount is for 4 employees and Salary is for 5 employees as one employee did not do any Overtime.
However Final output is generated for each employee 4 times also for employee who does not have any OT hours
I have gone through the online classes and tried in my own way
Please find attached the Access Data base and help
Thank you