G
Guest
I have 2 columns that I want to return a single list of unique values.
I'm using the query in a combobox of a form.
example
Table 1
Column 1
apple
pear
peach
Table 1
Column 2
apple
grapes
orange
pear
I want to return one list that would be...
apple
grapes
pear
peach
orange
thank you in advance for any input....
I'm using the query in a combobox of a form.
example
Table 1
Column 1
apple
pear
peach
Table 1
Column 2
apple
grapes
orange
pear
I want to return one list that would be...
apple
grapes
pear
peach
orange
thank you in advance for any input....