I am using the ValueList() function to return a comma-separated list of values
from a specific column in the results of a query.
My query returns about 300 records, but there are only two distinct values (6
and 7) in that column. My ValueList() returns a string of 6s and 7s.
Everything I use after that based on the ValueList works, but having the long
string of 6s and 7s just doesn't seem right. Is there a way to get only unique
values, so that 6 and 7 appear in the list just once?