access 97: duplicates in query

[JMCN]

i am receiving unwanted duplicates in my select query.
so i added the "distinct" in the sql side and/or i
selected the properties "unique values" = yes. However,
i receive an error message "can't include memo
or ole object when you select unique values
([Comments] & "" & [wire_text] & "" & [claim_user_nm])."

i understand that there are duplicated values within the field
called comment:([Comments] & "" & [wire_text] & "" & [claim_user_nm])
and i need them. how can i avoid this error message?? would i have to
go into the tables
and change the datatypes of [Comments],[wire_text], and
[claim_user_nm] fields to text? though
i need to have more than 255 character spaces for the comments field.
so i'm stuck and i really don't know what to do next.

any advice would be appreciated!! thanks in advance jung.

SELECT DISTINCT DEC_DDA_CR.DataBase, DEC_DDA_CR.LoanAcct,
DEC_DDA_CR.DDA, DEC_DDA_CR.Amount, DEC_DDA_CR.TXNum,
DEC_DDA_CR.TXType, DEC_DDA_CR.DocType, DEC_DDA_CR.DueDate,
DEC_DDA_CR.UserCode, DEC_DDA_CR.DetAmount, ([Comments] & " " &
[wire_text] & " " & [claim_user_nm]) AS Comment, DEC_DDA_CR.[Account
ID]
FROM qryLiveWire INNER JOIN DEC_DDA_CR ON qryLiveWire.amount =
DEC_DDA_CR.Amount
WHERE (((DEC_DDA_CR.TXType)="UNKNOWN"));

[JMCN]

pi******@yahoo.fr (JMCN) wrote in message news:<27**************************@posting.google. com>...

i am receiving unwanted duplicates in my select query.
so i added the "distinct" in the sql side and/or i
selected the properties "unique values" = yes. However,
i receive an error message "can't include memo
or ole object when you select unique values
([Comments] & "" & [wire_text] & "" & [claim_user_nm])."

i reworked the problem and realized that there are duplicate values in
both the [wire_text] and [claim_user_nm] fields. how would one allow
the duplicate values for only these two fields? is it possible?