I have query which has a SELECT DISTINCT statement. When I try to run this query it runs but before displaying the data it gives me a data mismatch error. When I remove DISTINCT it works fine - but I need to have DISTINCT. Does any one know why this is happening and who to correct it?
Thanks.

I have query which has a SELECT DISTINCT statement. When I try to run this query it runs but before displaying the data it gives me a data mismatch error. When I remove DISTINCT it works fine - but I need to have DISTINCT. Does any one know why this is happening and who to correct it?
Thanks.

Could we see a copy of the Query in question? After all, there could be a lot of reasons for something like this to happen, and all we would be able to do at this point is guess.