So what I have done to work around this issue is to change my Data Source for the connection to the AS400 from "Other (ODBC Data Source)" to "IBM DB2...

Well, I guess I'll answer my own question on this one...

The value in the AS400 was actually incorrect. SQL2000 seemed to be more "forgiving" and allowing this to come...

Also, how would this work on a single table? Is it possible if I am trying the same thing but on 1 table? Thanks!

Very close, but the distinct count is giving me a value of '1' since it truly is a distinct record. The Customer Price group is what makes the record...