"Data type mismatch" error

S

Sasha Furr

I have a query which, when run without the Distinct
keyword, runs fine - except it returns 3 of each record.
I set "unique values" to true in the query designer so I
will only get one copy of each record (same as using
Select Distinct in SQL). When I run it like that, I get
the error "data type mismatch"!

HOW can the query run fine w/out Distinct - performing the
calculations without returning any errors -

but then give me this error when run with Distinct???

I don't understand!

Sasha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Internal Data Integrity (Type 4) Details Needed 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Boolean data type mismatch 6
Totals Query with Multiple Counts 3
Unique Values + UNION = ERROR!Q 5
Data type mismatch error 2
Data mismatch error 2
Writing A Select Statement To Return a Count Of Unique Dates In aTable 2

Top