Jump to content


Photo

Limiting Count()


  • Please log in to reply
No replies to this topic

#1 MeanMrMustard

MeanMrMustard
  • New Members
  • Pip
  • Newbie
  • 5 posts

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