CODEWITHSUNDEEP
sqldatabasems-accessunionunion-all
NormX
NormX

Reputation: 125

Combine Multiple Columns in one Column MS Access

So i have multiple Columns with the same data type entry but i need to combine them into a single column. i have 25 columns id like to list in one column in the same order

Example:

D1 D2 D3 D4
15 19 16 22

Ds
15
19
16
22

Upvotes: 0

Views: 394

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269553

I think you jus want union all, as your tags suggest:

select d1 as ds from t union all
select d2 as ds from t union all
select d3 as ds from t union all
select d4 as ds from t ;

Upvotes: 3

Related Questions