Removing duplicate values??

[angelala]

I can't figure out how to pull up only one entry for duplicate values. For instance, I need to make a list of fax numbers but I only need each number once. How do I remove the rest of the duplicate fax numbers from my query?? Thanks!

 

[David R]

In Query Design View, right click on a blank area, go to Properties>Unique Values: Yes

 

[Hornet]

I figured out this bit of code, which I use to find duplicate usernames that will do another function once the Query finds the duplicate username.

Place this in the criteria box where you want to look for duplicates.
And of course edit the areas with [something] to fit your DB.

In (SELECT [AUI/UUNet Username] FROM [Current UUnet users] As Tmp GROUP BY [AUI/UUNet Username] HAVING Count(*)>1 )

 

[Rich_Lovina]

And yet another way if you want a table of the unique set is to set yr sigma sign on, change query to make table and put that uniques set of fax nos in another table.