We help IT Professionals succeed at work.
Get Started

Created a query that needs to update a table before I start a process

cres1121 asked
Last Modified: 2016-02-11
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.
Watch Question
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE