Append to table

[hendrikbez]

Thank you John



Just one last question, is there a easy way to see duplicates in table
tblSynonyms

I know there is and I need to take them out, maby a list of them

[accesstos]

No problem! That's too easy.

For dublicates:

SELECT tblSynonyms.TheWord, Count(tblSynonyms.TheWord) AS appearances
FROM tblSynonyms
GROUP BY tblSynonyms.TheWord
HAVING Count(tblSynonyms.TheWord)>1;

For unique words:

SELECT DISTINCT TheWord FROM tblSynonyms;

Cheers

[hendrikbez]

John

Thanks for all your help on this.

[accesstos]

John

Thanks for all your help on this.

You're welcome!