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