newbie question-unique records

  • Thread starter Thread starter Holstein
  • Start date Start date
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.
 
Try adding the keyword "DISTINCT" at the beginning of your
select statement, i.e., Select Distinct ...
 
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?
 
Back
Top