Remove duplicates in a lsit box

  • Thread starter Thread starter kris
  • Start date Start date
K

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.
 
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.
 
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.
Click to expand...

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