I use a query to create a calculation but I need it to update a field in a particular table. Before I run payroll I need to determine gross profit for 2014 and 2015. I need it to update a field for each salesmen based on year. This determines the percentage of commission they will get. I have a query that will determine the gross profit based on year. How do I get it to update a table? I don't know vb at all. My query is qrytodeterminetotalgrossprofit and the field is sumofgrossprofit. It also has employeeid, transyear the table to be updated is tblcommissiontotal and the field i need updated is total sales. I also have paidinyear and employeeid.
Any help would be appreciated.