Hide Duplicates

R

Rajtomar

I have a combo box in a Access 2002 program which looks up value by
this query - SELECT [TCANDIDATES FEEDBACK].[Record number],
[TCANDIDATES FEEDBACK].[Course Name] FROM [TCANDIDATES FEEDBACK] ORDER
BY [TCANDIDATES FEEDBACK].[Course Name];

I want to hide same course names appering again and again so i tried -
SELECT DISTINCT [TCANDIDATES FEEDBACK].[Record number], [TCANDIDATES
FEEDBACK].[Course Name] FROM [TCANDIDATES FEEDBACK] ORDER BY
[TCANDIDATES FEEDBACK].[Course Name];
but it didn't work.It gave syntax error

Can someone tell me whats the correct syntax to hide the duplicates.
 
R

RonaldoOneNil

Assuming Record number is unique there are no duplicates.
To remove the duplicate course name, you would have to remove the record
number.

SELECT [TCANDIDATES FEEDBACK].[Course Name] FROM [TCANDIDATES FEEDBACK]
GROUP BY [TCANDIDATES FEEDBACK].[Course Name] ORDER BY [TCANDIDATES
FEEDBACK].[Course Name];
 
R

Rajtomar

Thanx, it just worked fine. Although i also had to change properties
of combo box - Column count from 2 to 1 and Bound Column from 2 to 1.

Thanx a lot
 
Top