I am trying to use a make-table query to concatenate 8 text fields from an original table into a memo field in the new table. Unfortunately, Access wants to create this new field as a Text type. Even after going into Options > Tables/Queries > Default text field: memo, Access still wants to create the new field as Text. There has been a similar question posted on Experts Exchance that was never technically resolved. Anybody know how to do this effectively?