In addition to Sevdalina's reply check
Eliminating duplicates in a table FAQ #8129
>Hey guys,
>
>I'm having a problem regarding on how am I going to delete records in a same table if that record already exist. Here's the situation
>
>for example I have a Table called myTable
>
>and this table have a record of.. lets say
>
>dog
>cat
>chicken
>goat
>cow
>dog
>cat
>
>how can I delete the duplicate record if those records belongs in a same table.
>
>Another problem is what is the syntax in subtracting two time entries.
>
>ex. I want to get the minutes difference of 18:30 to 08:00.
>
>Thanks a lot.
If it's not broken, fix it until it is.
My Blog