Don't realy get the problem as in what you are count and what is not beying counted (maybe some later reply from somebody else is more usefull)

For now i can only sudject to change the "zero" value's to value + 0.00001 for example

this is a very small impact in your totals and witch a 0.xx max value behind the 0. it will not be visual unless you have 500+ sales of that article.

 

hope this helps a bit.

 

Greetz

 

Adam

Wouldn't this be an issue of looking at quantities and not at price?

 

before i use price <> 0

 

i get this

 

 

quantity      item          rep      customer        price

 

      3           milk           bob          1111            23

      6           wine          gill           2221            45 

      3           milk          paul          4534              5

      1           pen          paul          3333              0

      1           pen          paul          3333              6

 

after i use price is <> 0

 

i get

 

I'll hazard a guess that when you use the select statement of price <>0 it is either making a left join into an inner join or dropping extra values from an extra link somewhere along the line. I doubt it is coincidenta that your item and customer are the same for oth items that were dropped.

 

That being said you should be able to easily get your numbers using Running Totals that conditionally count or sum your fields where table.price <>0 without worrying about dropping records via the select statement.