Combining Fields

[Frederico Carmo Reis]

I would like, if possible, some help to try and join two fields in
Access
The problem is that I don't want to "join" the two fields, I want to
create one field with information (without duplicates) from the two
previous ie. I try to join Field 1 with Field 2, wanting the Field 3
to be like in the example :

Field 1 Field 2 Field 3
123 123
134 134 134
156 156
178 234 178
190 456 190
234
456

I hope to have explained my problem correctly.

Thank you very much

 

[Michel Walsh]

SELECT field1 FROM somewhere
UNION
SELECT field2 FROM somewhere

(in SQL view of a query, you cannot define UNION query with the Access Query
Graphical tool).



Vanderghast, Access MVP