I have a combo box based on Table/Query as follows:
Select Distinct Assessment.[Assessment No],Assessment.[COO Officer]FROM Assessment;
It displays duplicates COO Officer. If I remove the Assessment No field, the combo box is blank.
How do I fix this to just show distinct COO Officer?
I have ready many posts but don't seem to find an answer that works. I do have Unique Values set to Yes.