MsAccess Query problem

[vishnukamath]

hi, i wrote msAccess query like. SELECT T1.[CID],T2.[Name] FROM T1 INNER JOIN T2 ON T1.TID =T2.TID WHERE T1.CID in ('select CID from T3') here i'm getting error : "Cannot join on memo,ole,or hyperlink object (T1.TID =T2.TID )" please send solution for this Thanks & Regards, Vishnu.

[Mycroft Holmes]

So one of your fields is in this data format, check each field in the join and change the data type of the offending field.

Never underestimate the power of human stupidity RAH