Unique Values v Unique Records

[Mary Ann]

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?

 

[John Spencer]

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

 

[Jason Lepack]

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?

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

 

[Mary Ann]

Thank you Jason

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

 

[Mary Ann]

Thank you John

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