newbie question-unique records

[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.

 

[mark]

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

 

[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.

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?