No replies to this topic
Posted 19 April 2006 - 10:46 PM
I'm working on an incentive site.
Each employee has a monthly goal - say 20 products.
Each product has two incentive values - 2.00 if the total number of products sold is less than 10. $5.00 if products sold equal 11 or more.
I'm trying to do a Sum and Count all in the same query.
I want to know the sum of the first 10 products and then the sum of the remaining products. I have about 30 products each with different values so I can't limit it by value.
Any help would be appreciated...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users