Change table or field in MS Access 2010 table from multi-valued to normal table or field.
I have table with several multi-valued fields. Table is populated with data.
I want to change this table that those fields are not multi –valued .
How to do that?
I tried to create the table with same fields and append multi-valued field table to this not multi-valued but it will not allow me to do it get error that source or destination of query could not be multi-valued table.