Cindy,
A special thank you to you. You always seem to jump right in. Your input has been a tremdous help! :-) Thanks to the other guys as well.
I usually don't have any porblems with my SELECT's but here lately, the data we have been recieveing has been causing all kinds of wierd stuff to happen. When ever I am able to figure out what has happened, it usually has to do with records that are exactly alike. I mean ever fileds is the same. The data is not duplicated in this case but rahter another sale thatjust happen to have the same elements. When this does happen, you can bet the SQL will only count or Sum one of them instead of all of them and leave them out.
Should I send you some data or something? It think I can find some examples.
Thanks in advance for your help! :-)
Randall L. Johnson