Query - type mismatch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

azn_anjool - 15 May 2005 09:40 GMT

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!

Reply to this Message

Jeff Boyce - 15 May 2005 12:33 GMT

Check to see that the fields being join are of the same data type.

Signature

Good luck

Jeff Boyce
<Access MVP>

> Hi im trying to create a query...and everytime i try to run it it says
> "type mismatch" but this only happens when i have my linking table
[quoted text clipped - 3 lines]
>
> HELP!!

Reply to this Message