Combining Fields

  • Thread starter Frederico Carmo Reis
  • Start date

Frederico Carmo Reis

I would like, if possible, some help to try and join two fields in
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

I hope to have explained my problem correctly.

Thank you very much

Michel Walsh

SELECT field1 FROM somewhere
SELECT field2 FROM somewhere

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

Vanderghast, Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question