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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total appointments per agent 2
Show select table entries based on yes/no checkbox answers 1
query syntax / layout 1
name query 1
Access 2007 - check for existing record 1
MANY 'or' criteria 1
Query Not Displaying All Main Table Records 1
Crosstab not showing null values/fields 5

Back
Top