Hide Duplicates

  • Thread starter Thread starter Rajtomar
  • Start date Start date
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.
 
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];
 
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
 

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

Back
Top