How do I select distinct values from a field with numerous duplicates in both
a drop down list and text box.

I am trying to design a form that has its query as a drop down list from a
field containing duplicates, then query from this to return a unique name,
address etc for use in a form.

In Access youuse the "select distinct" function, and aparently this can be
used in SQL and Xpath but I seem to get the syntax wrong.....

I have read the other examples in here but they don't help.