Data mismatch error when running a query with a DISTINCT statement

[accessaspire219]

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.

 

[MSAccessRookie]

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.