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: tenn_tazz26@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar