remove duplicates from drop down list

[Guest]

I have a form with a drop down lists of names that are in the Sponsor Name
field of my table. I have the Row Source type is set to Table/Query and the
Row Source is set to:

SELECT [Games of Chance - Master Table].[Sponsor's Name] FROM [Games of
Chance - Master Table] ORDER BY [Sponsor's Name];

I use this to help with the data entry, but several records have the same
name, so the same name is listed multiple times in the drop down list, how
can I remove the duplicates from the drop down list?

 

[Guest]

Change to SELECT DISTINCT[Games of Chance - Master Table].[Sponsor's Name]
FROM [Games of Chance - Master Table] ORDER BY [Sponsor's Name];
The disctinct will give unique values

 

[Guest]

Hi Ginny -- You can use either the DISTINCT or GROUP BY clause...

SELECT DISTINCT [Games of Chance - Master Table].[Sponsor's Name] FROM
[Games of Chance - Master Table] ORDER BY [Sponsor's Name];

or

SELECT [Games of Chance - Master Table].[Sponsor's Name] FROM [Games of
Chance - Master Table] GROUP BY [Sponsor's Name] ORDER BY [Sponsor's Name];

However, I am unable to tell you what the technical differences between the
two. Hopefully an MVP can shed some light on the subject...

 

[Guest]

THANK YOU BOTH, THAT WORKED FANTASTIC!!!
--
Ginny

Change to SELECT DISTINCT[Games of Chance - Master Table].[Sponsor's Name]
FROM [Games of Chance - Master Table] ORDER BY [Sponsor's Name];
The disctinct will give unique values

I have a form with a drop down lists of names that are in the Sponsor Name
field of my table. I have the Row Source type is set to Table/Query and the
Row Source is set to:

SELECT [Games of Chance - Master Table].[Sponsor's Name] FROM [Games of
Chance - Master Table] ORDER BY [Sponsor's Name];

I use this to help with the data entry, but several records have the same
name, so the same name is listed multiple times in the drop down list, how
can I remove the duplicates from the drop down list?