memo field distinct rows

[Jivko T]

hi group,

is there a way to obtain rows with distinct mem fields

the expression "select distinct my_memo_field from my_table"

raises error "the field is too small to accept the amount of data you
attempted to add ..."

the expression "select distinct my_date_field from my_table" works perfect!

any suggestions?

thaks!

 

[Arvin Meyer]

Trick it. Try this:

SELECT DISTINCT Left([MyMemoField],2500) AS Expr1
FROM tblMyTable;

This will check the first 2500 characters. Actually the first 500 characters
is probably enough for most uses.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access