Convert Memo Field to Text in make TBL Query

[bcarneyAEP]

Hi
I am trying to convert a Memo field to a Text field in a Make Table query. How can I do this?

Thanks In advance

Brian

 

[MSAccessRookie]

Hi
I am trying to convert a Memo field to a Text field in a Make Table query. How can I do this?

Thanks In advance

Brian

A Table that is created by a Make Table Query is entirely based on the data types of the Fields that are selected. As long as the Make Table Query Field in question is a Text Field, then the new Table will also have a Text Field.

Your only concern should be what to do if any information is lost during the process of converting the Memo Field to a Text Field, since the Memo Field could hold far more data than a Text Field.