Make-table Query property?

[dgmorr]

I am having trouble with a make-table query. I run a query that populates my website with data daily. I have a bunch of fields in the db that I wanted to be displayed as one field on the website, so in my query I concatenated them. My website is able to distinguish which fields are text and which are memos so I can display multiple lines. Everytime I run the query, it creates the concatenated field as a text field. Is there a way I can default this to a memo type?

Thanks.

 

[boblarson]

Yes, don't use a make table query, but use a delete query to clear the table and then use an append query to put the new data in.