CalculateFieldGreaterThan255

  • Thread starter Thread starter DZ
  • Start date Start date
D

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.
 
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.
 
Back
Top