While DISTINCT will bring results of only one record per SoldToCMAcountNo from the first query listed below, it has no effect from the second query as there are more than one field specified in the SELECT statement.
>How Do I alter the second query so that there is only one record per SoldToCMAcountNo. resulted in the query?
"SELECT DISTINCT SoldToCMAccountNo FROM etc.
"SELECT DISTINCT SoldToCMAccountNo, ID, DocStatus FROM etc.
>How Do I alter the second query so that there is only one record per SoldToCMAcountNo. resulted in the query?
"SELECT DISTINCT SoldToCMAccountNo FROM etc.
"SELECT DISTINCT SoldToCMAccountNo, ID, DocStatus FROM etc.