Tables :: Comparing One Record To Another?

Let's say table looks like this.

Name Type Amount Percent Bonus
John DCP 5000 10
John Sales 4000 5

I need to look at record one and if John's DCP Amount is >=4000 AND his Sales are >=4000 his Bonus amount for DCP would be 5000 * 10 and his Sales Bonus would be 4000 *5 but if the DCP was not >=4000 he would get no bonus for DCP and no bonus for Sales because DCP drives his bonus.

So even if Sales were >=4000 because DCP was not the result would be 0 for both. Make since?

Is there any way to evaluate this without using VBA?