Copy memo field

[gasca]

Hi,

I'm trying this query in access

INSERT INTO _AlbumsImport(Album, Anyo, Comentario)
SELECT DISTINCT Album, Year, Comment
FROM _Import

and it says cannot copy 'comment' memo field to 'commentario' cos it's too long. I think that error is because DISTINCT cannot be made of a memo field, but how could it be done supposing every album and year correspond to the same comment?

Any help will be appreciated.

 

[Jamfool]

I think more than likely you should check your table construct. Make sure the data you are inserting will fit into your target table.