summary

[Dan]

i have a table and it has duplicate names in it, but i
only want to see the name once how can i query this?

example

Jones Jone
Jones
Frank Frank
Frank
Frank

 

[Daniel]

Dan,

change your query to a total query the "group by" will do as you want.
Also, check your help files for "GROUP BY Clause" you should get some more
info there.

Hope this helps,

Daniel