CalculateFieldGreaterThan255

[DZ]

In a query I created a calculated field that results in
text that is more than 255 characters. The data is
truncated. Ultimately I want to turn this query into Make
Table Query but the results will be truncated. is there a
way run this make table query so that the calculted fields
are memo fields instead of text fields so the data won't
be truncted.

 

[Jeff Boyce]

Don't use a make table query. If you first define the table structure,
including your memo fields, you can use an append query instead.