Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repeat Data in a field

Status
Not open for further replies.

Gti

Programmer
Jul 23, 2001
99
PT
I have a table with a field and this field have data, but are in that field equal datas.

e.q

Field "Name"

john
jonh
paul
paul

---------------

I want a query that can give me the names but, can't repeat equal names.

Any help

Tkx :)
 
Use a group by query and group by name. This will suppress the dups. Maq B-)
<insert witty signature here>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top