CODEWITHSUNDEEP
ms-accessms-query
Thyreme
Thyreme

Reputation: 17

Two Table columns into one Query

I'm trying to bring data from two different columns into one query field. Example: Table1 [Field1] and [Field2]. I don't know if that's possible but in my Query I'm trying to bring the datas from these two Fields and show into one in Query. e.g.

|Table|

|DepartureDate1 | DepartureDate2|

| 15 Nov 2021 | 20 Nov 2021 |

|Query|

|DepartureDate1&2|

15 Nov 2021

20 Nov 2021

Thank you in advance.

Upvotes: 0

Views: 58

Answers (1)

Kostas K.
Kostas K.

Reputation: 8518

Try using a UNION.

SELECT DepartureDate1 AS [DepartureDate] FROM Table1
UNION
SELECT DepartureDate2 AS [DepartureDate] FROM Table1

Upvotes: 1

Related Questions