Good afternoon.
I am trying to figure out a way to add totals together from different tables/queries.  

I have two different groups of employee's. I run a farm and also have a trucking business.  Employee group 1 gets paid salary and also get bonus's when they haul a certain amount of loads.  Employee group 2 gets paid a hourly wage and also get paid by the load when they truck.  I am probably overcomplicating this but it seems to be working.

I track my employees that get paid salary/hourly wage/per load compensation(is a %) on an employee table.  The employees that work by the hour have another table that tracks their hours.  Now table 3 tracks the loads that they haul.  I would like to bring the totals from these tables together for payroll and track their compensation along with taxes for the pay period and annually.  Any direction for a video I can watch or group of videos?