Unique Values Property - how to display additional fields not uniq

[SG_BA_LA]

Hi Access Wizards,
I have been using the Unique Values property in the query design window. The
only problem is that it uses all the fields to create one unique result. What
I need help in is to run the query using the unique values property to filter
out the duplicate records using one field and, in the result set, display all
the other fields.
For example: Customer ID (is unique), but Servicing Broker ID is not. I need
both to display along with others... address, etc.
Any help would be greatly appreciated!

 

[Klatuu]

Use the Find Duplicates query wizard.

 

[SG_BA_LA]

Thanks. I'm at work and we don't have it installed. Is it available for
download at MS?

 

[Klatuu]

Are you sure?
select your queries tab, then in the dialog you should see it.
I don't think it can be downloaded.

 

[SG_BA_LA]

Checked again in Tools - Add-in - Add-in Manager and it's not there. Darn!

 

[John Spencer]

No it is not in the menu under Tools - Add In.

It is found when you click the NEW button on the query page. One of the
choices there is Find Duplicates Query Wizard.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..