Multi-Valued fields not allowed error

[WineSnob]

I am trying to merge 2 tables into 1 and I get an error "Multi-Valued fields are not allowed in SELECT INTO statement" error when using the Make Table query. How do I find the offending field? Between the 2 tables there are close to 75 fields.

 

[vbaInet]

Multi Values fields branch off or have a + sign next to them.

 

[Galaxiom]

75 fields is rather a lot. Is the data properly normalized?

 

[WineSnob]

Actually (I counted) it is 133 fields. I am coverting a 18 year old DOS based foxPro db to Access. Many fields are not being used and will be deleted once I complete the conversion. Right now I do not want to delete any data fields until I understand the need and use. I created a select query and exported it to excel and then imported it back in as a table. I am set for now. Thanks for your response.

 

[vbaInet]

I am coverting a 18 year old DOS based foxPro db to Access.

You must be having lots of fun

 

[WineSnob]

More than you can imagine.