How do I indicate the field types when creating a new table while using an MS Access Make Table Query?
I am trying to create an Access table by using a make table query that contains an expression to build a concatenated data field. The expression uses the Dconcat function created by Patrick Matthews which is very helpful for putting together the data into one field, but the problem is that the data being concatenated sometimes goes over the 255 characters limit that is created by default when the make table query runs. I need to know how to indicate in the query to make the field be of "Memo" type instead of the "Text" type that gets created by default so that the data will fit in the field as needed. Any assistance with solving this problem will be greatly appreciated. Thanks! DConcat-SampleData-jb.accdbDConcat-SampleData-jb.accdb