By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

access 97: duplicates in query

P: n/a
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"));
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.