help with query

K

Kay

I have ran a query, got all the info, I plan on making
labels out of it in a report. However, I have duplicate
records, I have tried everything. When I simply try to
delete the record it tells me it is a "read only". I have
tried setting the "unique records" option in the
properties and that is not working. Any other hints?
Thanks, Kay
 
R

Robbie

Instead of Unique Records try the "Unique Values"
property. This adds the "Distinct" keyword in the SQL
statement.

HTH
 
K

Kay

I just tried the "Unique Values" property, and it din't
work. And I don't know what the SQL statement is either.
If you could give me some info, that might be my problem,
I am totally lost.

Thanks, Kay
 
Top