Allen Browne's concatenate function - don't display duplicates?

[canfish]

Hi all,



I am using Allen Browne's concatenate in one field code in order to display all of the entries in a field in one entry on the query. This is working fine for me. But I would like to take this a step further, and I'm not sure how to make the changes:

I want to have the function not display any duplicate items, so if it was originally:

JetwayFunction, JetwayFunction, JetwayFunction, StewFunction, StewFunction, PlatterFunction

It would turn out:

JetwayFunction, StewFunction, Platterfunction


Does anybody know if there is a way to do this?

Thanks so much!

canfish

[pbaldy]

This is utterly untested, but you can try modifying this line to:

strSql = "SELECT DISTINCT " & strField & " FROM " & strTable