summary

D

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
 
D

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
 
Top