Query - type mismatch

  • Thread starter Thread starter azn_anjool
  • Start date Start date
A

azn_anjool

Hi im trying to create a query...and everytime i try to run it it say
"type mismatch" but this only happens when i have my linking tabl
open...but then when i get rid of it...there is no link between th
remaining two tables and hence the results returned is all th
combinations available..

HELP!
 
Check to see that the fields being join are of the same data type.
 
You must log in or register to reply here.

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

Type Mismatch in Expression 1
Number to Number "Data Type Mismatch in Expression" in Join 1
Error: Data type mismatch in criteria expression 0
i am getting the message "Type Mismatch" 1
Access SQL Query: Data Type Mismatch on TimeValue condition 3
Type Mismatch 2
data mismatch 2
Data mismatch error 2

Back
Top