Unique Values v Unique Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a list of sites in it, some of which are repeated.

I want to produce a list with no repeats.

I have created a query and used the Unique Values property and that seems to
work. But it doesn’t make sense to me – I would have thought I would have
needed Unique Records. What is the difference between these two properties
and am I correct in using Unique Values?
 
Yes, you are correct in your choice.

Simplified explanation:
Unique values looks at the fields that are being returned and uses only
those fields to create a set of unique records.

Unique Records looks at all the fields in the tables (including the ones you
have chosen not to display) to create the set of unique records.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I have a table with a list of sites in it, some of which are repeated.

I want to produce a list with no repeats.

I have created a query and used the Unique Values property and that seems to
work. But it doesn't make sense to me - I would have thought I would have
needed Unique Records. What is the difference between these two properties
and am I correct in using Unique Values?
Click to expand...

When you select Unique Values you get all of the DISTINCT values.
When you select Uniqe Rows you get all the DISTINCTROW s. You need to
use Unique Values for your situation, but look up the page below to
familiarize yourself.

Check this out for DISTINCT and DISTINCTROW.
http://office.microsoft.com/en-us/access/HP010322051033.aspx

Cheers,
Jason Lepack
 
Thank you John

John Spencer said:
Yes, you are correct in your choice.

Simplified explanation:
Unique values looks at the fields that are being returned and uses only
those fields to create a set of unique records.

Unique Records looks at all the fields in the tables (including the ones you
have chosen not to display) to create the set of unique records.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Click to expand...
 
Back
Top