Creating a query that lists things only once

[Ryan Maki]

In my database, records have a name associated with them. Some people are associated with more than one record. I would like to run a query that will only show each persons name one time. Is this possible?

Thanks,

Ryan

 

[steve_colman]

Guy,

Go to the menu View and select Totals.

In the actual query ensure the 'name' field total option are set to group by. This will solve this for you.

 

[Cbrine]

Do as Steve stated, but also put an extra field in the query, doesn't matter what field. Set the total on it to count, then click on the display checkbox, so it doesn't appear. This should give you a listing of unique names in the table.

 

[Norie]

Cbrine

I don't think you need to do this - the group by should do it.

 

[Cbrine]

Well, I'll be damned. I tested it, and you are right. All thoses needless counts I've always did my unique lists with a count. I guess you never stop learning.

Sorry steve_colman.