Does a Select query copy memo fields correctly?

[Guest]

I created a select query to get different fields from different tables. Two
of the fields are Memo fields. Both of the fields are truncated at 255
characters. I created an Update query to see if it would handle the Memo
fields correctly and it performed as it should. Is there someway to get a
select query to handle the Memo fields correctly?

 

[John Vinson]

Is there someway to get a
select query to handle the Memo fields correctly?

Just be sure that you don't Sort or Group By the memo field, nor apply
any format to it.

John W. Vinson[MVP]