Appending Tables with Multivalue Field

[Dhamdard]

Dear Access experts,

I have two tables "Tab_Issue_1" and "Tab_Issue_2". Tab_Issue_1 has two fields "Issue" and "AssignedTo". Tab_Issue_2 has the same fields. However, the "AssignedTo" is a multi-value field in both tables. I want to append data from Tab_Issue_1 into Tab_Issue_2. I use the following SQL but it pops up this message "An INSERT INTO query can not contain a multi-valued field".

[SQL]
INSERT INTO Tab_Issues_1 ( Title, AssignedTo )
SELECT Tab_Issues_2.Title, Tab_Issues_2.AssignedTo
FROM Tab_Issues_2;
[SQL]

Your help will save my day. I already spend half day playing with it but with no luck so far.

Thanks,
Dhamdard

 

[llkhoutx]

A field cannot be multi-valued. Use a text field to concantenate multiple values separated by a ;. the use the split function to get those various values.

 

[spikepl]

Everybody and his brother will tell you not to use multivalued fields, because of various complications of which you just encountered one. Use sub forms. If you do insists then Google Microsoft's documentation of insert queries and multivalued fields.

 

[Dhamdard]

I also came to the conclusion not to use MVFs anymore. I redid all my work. I hope Microsoft engineers improve the way MVFs can be used.

Thanks,
Dhamdard