Randall,

If your records are otherwise exactly the same, you need a way to distinguish them. This is usually done with unique keys. All of my tables have auto-generated "line numbers" whether I "need" them or not!

If you can find an example of a case where you did not get the desired results, send me a minimal amount of data, and the code you're using. I'll look at it and post back to this thread (or a new one) so everyone can learn from the situation.


>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.