How can I remove duplicates from list box
Posted on 2008-10-14
I have the following SQL statement:
SELECT DISTINCT XKIncidentTasks.IncidentTaskID, XKIncidentTasks.Sequence, XKIncidentTasks.IncidentTask, XKIncidentTasks.IncidentTaskDuration
ORDER BY XKIncidentTasks.Sequence;
My table XKIncidentTasks contains 59 records. All have an autonumber which is "IncidentTaskID". Around 15 of these records all contain the same text in the field "IncidentTask". I would like to remove these 15 records from my list box. I do not want to delete them from the table.
I have tried using the DISTINCT coding in my SQL but this does not work because Access does not see any duplicate records due to the "IncidentTaskID" field. I need the "IncidentTaskID" to be present in my list box.
Can anybody help me?