Total unique fields

  • Thread starter Thread starter Cathy C
  • Start date Start date
C

Cathy C

I'm querying a table with criteria which yields SSNs. Some of the SSNs are
duplicates since they have more than one product. I just want one instance
of each SSN. I know I can append it to a table that has SSN as a primary
key, but is there a one-step query that yields this information without
having to create a table?

Thanks,
Cathy
 
IF all you are returning is the SSN you can get the result in a couple of
ways.

Assuming that you are using the design view (query grid) then

-- Click in the area that displays the tables, but not on a table
-- If properties is not showing, select View: Properties from the menu
-- In the property sheet, set Unique Values to yes
(This will show only one record for each combination of values that are
displayed)

Your other option is to use an aggregate (totals) query.
-- Select the fields you want to display
-- Select View: Totals from the menu
-- Leave Group by under the SSN field
-- If you have other fields that have differing values, then replace Group
By with First, Max, or Min to return only one value for those fields

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Thank you so much!! I knew there had to be an easier way. The first option
did the trick.
 
Back
Top