[MS_AccessPros] Re: Cannot joing on Memo, OLE, or Hyperlink Object

 

Dale

You cannot join on a memo field. Joins are done on the primary key of one table and the foreign key of the child table. The data types have to be the same or at least compatible (like integer & long). Can you post the table structures (the field names and data types)? Be sure to note the primary keys.

Also tell us what you are trying to do with the data.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <tenn_tazz26@yahoo.com> wrote :

I am getting the above error when trying to create a query from flat lined tables that are created by our company. I have two tables I am linked to. In table1 I am trying to join question_id to item_code in table2. That works without any problems. When I do the join I make it so it uses a right outer join?? (The one with the arrow pointing to table2). In table1 I also am trying to link Response_data to item_choice_code using the same type of join. This is when the error happens. When I check the tables I think it is because Response_data is a memo type and  item_choice_code is a number. I don't have write access to the table structure to be able to change it. Even though in Response_data it may have a number 2 and in table2.item_choice_code it also has a number 2 and another field called item_choice_text which represents what the number 2 means, Access does not like the fields to be different. How can I get around this?

Thanks,

Dale 

 

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___