ms-access - 访问 2016 将多字段附加到一个字段

Question

[![在此处输入图片描述][1]][1]大家好。

我有一个表格，其中包含一些字段，例如附件 T_Jadwal2.jpg。https://i.stack.imgur.com/mPuBg.jpg我需要将表格插入到其他表格中，格式不同 ， 例如 T_Jadwal3.jpg https://i.stack.imgur.com/hRg7y.jpg在查询中有解决方案将 T_Jadwal2 附加到 T_Jadwal3

谢谢你。

问候， 费尔南多

标签： ms-accessappendms-access-2016ms-queryjquery-append

Answer 1

像这样创建一个联合查询：

Select ID_Jadwal, [Shift], Supervisor As Nm_Karyawan, "Supervisor" As Posisi
From YourTable
Where Supervisor Is Not Null
Union All
Select ID_Jadwal, [Shift], Printing, "Printing"
From YourTable
Where Printing Is Not Null
Union All
Select ID_Jadwal, [Shift], Tinta, "Tinta"
From YourTable
Where Tinta Is Not Null
Union All
Select ID_Jadwal, [Shift], Cylinder, "Cylinder"
From YourTable
Where Cylinder Is Not Null
Union All
Select ID_Jadwal, [Shift], Dry, "Dry"
From YourTable
Where Dry Is Not Null
Union All
Select ID_Jadwal, [Shift], Extrusion, "Extrusion"
From YourTable
Where Extrusion Is Not Null
Union All
Select ID_Jadwal, [Shift], Slitting, "Slitting"
From YourTable
Where Slitting Is Not Null
Union All
Select ID_Jadwal, [Shift], Rewind, "Rewind"
From YourTable
Where Rewind Is Not Null

在追加查询中使用它作为源。