Removing Duplicate Fields

Hi All,

I've been working on this problem for 2 days now and I can't find a solution

I have a database in which looks a little like this

ID Name Address
1 anton 32 algi rd
2 lesly 24 smith st
3 bianca 32 algi rd
4 brian 92 faraday cres
5 bill 32 algi rd.

I want a query that will enable me to display all the names and addresses however if the Address is a duplicate (as in ID's 1, 3, 5) I don't want it to display the address 3 times. I only want it to display once.

However it gets more complicated I want one of the names (either anton bianca or lesley doesn't matter which) to show up with the address.

In other words I want the Query to output

ID Name Address
1 anton 32 algi rd
2 lesly 24 smith st
4 brian 92 faraday cres.

I have tried the

SELECT DISTINCT Address FROM Details

However I need the name and ID's to show up with the address!

Thanks very much in advance,

Anton

I think that you can use the 'find duplicateswizard' available from the drop down when creating a new query.
If that option is not available I think that you have to insert the disk you loaded Access from and add the additional wizards.
I hope this helps.

Jim