Multiple Name Query

[Kelly]

Hi-
I have a list where there are several names that show up
more than once. I need a query to have those names show
up only once as well as still show the names that already
show up once. Can I do this?

Thanks for any help!

Kelly

 

[Guest]

Build a query with following SQL

SELECT [Your List Table].[Your Names Field
FROM [Your List Table
GROUP BY [Your List Table].[Your Names Field]

This will list the names only once. If there are other fields that you want along with the name, you need to select the group type for each of those fields. You do this by selecting from the drop down in the Totals row.