Remove duplicates in a lsit box

[kris]

Hello,
I have a list box whose source is a column in a query's output.And
there is a possibility that two records have same value in that field or
column.So the list box is having duplicate values.
Is there a way to remove theses duplicate value.
Example : The query O/P is like
Name Marks Course
Tom 90 Database
Harry 91 Database
Jim 90 Database

"Marks" is the source of my list box.Now my list box contains 90, 91, 90.
I want it to be 90,91.
With no duplicates.

Please provide a detailed procedure as my knowledge on Access is limited.

 

[golfinray]

You should not have duplicates in your query and that is where you would need
to remove them. There is a find duplicates query under new query.

 

[Mr. B]

With the Properties dialog box of your query displayed, set the "Unique
Values" property to Yes. This will elimate the duplicate values from your
query.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Matt P]

Hello,
       I have a list box whose source is a column in a query's output.And
there is a possibility that two records have same value in that field or
column.So the list box is having duplicate values.
Is there a way to remove theses duplicate value.
Example : The query O/P is like
Name        Marks       Course
Tom             90          Database
Harry            91          Database
Jim               90          Database

"Marks" is the source of my list box.Now my list box contains 90, 91, 90.
I want it to be 90,91.
With no duplicates.

Please provide a detailed procedure as my knowledge on Access is limited.

Post your sql code so that we can edit it for you...