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?
Spencar Diedrich 19 months ago
I should also add that I am tracking all of these things separately and have totals on forms for them. I am just trying to bring them all together in one query to calculate compensation and tax's.
Adam Schwanz 19 months ago
What kind of problems are you running into just using a query to bring them all together? Sounds like a query should be able to do all of this for you, maybe would need a few custom expressions using DLookup
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.