在ms访问数据库中将多列移动到单个列 [英] Move multiple column into single column in ms access database

问题描述

在数据库记录中如下;



Sch_Date会话课程

2/25/2013 1 ARPA



i已将多列移动到该查询的单列，如下所示：



SELECT [Sch_Date]&[Session]&[Course]来自Tb_SCh_TIme_Table的消息



输出如下;



消息

2 / 25 / 20131ARPA



确定它正常工作，但我希望输出如下逗号如下;





我需要的输出我需要如下;



留言

2/25/2013， 1，ARPA



为什么我如何更改我的上述查询以获得ms访问数据库中的上述输出。





在下面的查询中如何更改，

SELECT [Sch_Date]&[Session]&[Course] AS来自Tb_SCh_TIme_Table的消息



来获得我所需的输出。





请帮帮我怎么办

In database records as follows;

Sch_Date Session Course
2/25/2013 1 ARPA

i have moved multiple column into single column for that query as follows,

SELECT [Sch_Date] & [Session] & [Course] AS Message from Tb_SCh_TIme_Table

Output as follows;

Message
2/25/20131ARPA

ok it is working, but i want the output as follows with comma as follows;


my required output i need as follows;

Message
2/25/2013,1,ARPA

for that how can i change my above query to get the above output in ms access database.


In the below query how to change,
SELECT [Sch_Date] & [Session] & [Course] AS Message from Tb_SCh_TIme_Table

to get my required output.


please help me how can i do

推荐答案

SELECT A & "," & B & "," & C AS D
FROM YourTable;

祝你好运，

OI

Good luck,
OI

这篇关于在ms访问数据库中将多列移动到单个列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！