newbie question-unique records

H

Holstein

Anyone willing to help a newbie out. I made a query that
is pulling duplicate entries from tables. Is there a
simple way to get only unique records. I tried changing
UniqueRecords to yes in the query properties. That didn't
work. Thanks in advance.
 
M

mark

Try adding the keyword "DISTINCT" at the beginning of your
select statement, i.e., Select Distinct ...
 
J

John Vinson

Anyone willing to help a newbie out. I made a query that
is pulling duplicate entries from tables. Is there a
simple way to get only unique records. I tried changing
UniqueRecords to yes in the query properties. That didn't
work. Thanks in advance.
Click to expand...

The Unique Values property checks all the fields you're including in
the query; if you include a Primary Key value then it is (by
definition) different in each record, so all the records are unique.

Could you perhaps post the SQL of your query and an example of the
duplicate data?
 
Top