We help IT Professionals succeed at work.
Get Started

I need a trigger for the user to know when a query hits a particular running balance total.

cres1121 asked
Last Modified: 2016-05-22
We pay commission levels based on gross profit.  If my salesmen hit 300000 the commission will move up from 9% to 12%.  I run payroll twice a month.  I need it to trigger me when we go over the 300000 and I need to know what is it behavior.  So if we are at 275000 in gross profit when the query reads the next record and the gross profit of 30000.  I need that the salesmen has gone to the next level but the calculation needs to do 25000 at 9% and the next 5000 at 12%.  I don't know VB and I am doing this with a select query and then a append query.  I do write each record into a paydetail table.  Any advice would be welcomed.  The signal can be a conditional format on the query but I do need two lines written in the table one at 25000 at 9% and then again 5000 at 12%.  I have three levels this needs to happen.
Watch Question
Social distance; Wear a mask; Get vaccinated
Top Expert 2014
This problem has been solved!
Unlock 1 Answer and 14 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