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.