Multiple Name Query

  • Thread starter Thread starter Kelly
  • Start date Start date
K

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
 
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.
 
Back
Top