Defining the types of fields that are created by a make-table query.

[Jonathan Lueb]

How do you define a field type when a make-table query is run?

It is creating a text field and it needs to be a memo field because it's truncating the data in the field because it is more than 255 characters.

Can this be done by modifying the SQL code?

Jonathan

 

[boblarson]

I would make the table initially and then modify the datatype, then use delete/append queries so you don't have to make the table more than once.