Fill 1 listbox, 1 column from two fields 1

[Domino2]

I have a listbox with 1 column. I am trying to fill it from two fields in a table to produce a distinct list? How can I do it if its possible. Thanks

 

[PHV]

Use the concatenation operator &

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Domino2]

Thanks PHV, however that puts the items side by side. I am trying to see if there is any way to avoid generating a common table and then filling the list. Might be the only way? Regards

 

[MajP]

You can use a union query
[tt]
fieldOne fieldTwo
------------------------
Car Dog
Bike Cat
Motor Cycle Dog
Motor Cycle Cat
Bike Dog
Dog Cat
Cat Dog
[/tt]

sql

Select fieldOne from tblOne UNION Select FieldTwo from tblOne;

output

[tt]
fieldOne
--------
Bike
Car
Cat
Dog
Motor Cycle
[/tt]

 

[Domino2]

Many thanks. Thats an easier way I never thought of.