第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號安全，請及時綁定郵箱和手機(jī)立即綁定
已解決430363個問題，去搜搜看，總會有你想問的

Microsoft Access壓縮表中的多行

Microsoft Access壓縮表中的多行

我在MS Access 2007中有一個問題，我希望有人有答案。我有一個很長但很簡單的表，其中包含客戶名稱以及交付周的日期。我想通過將名稱和所有日期列入一個新字段“ALLDays”，同時仍然保留所有數(shù)據(jù)來總結(jié)此表。源表看起來像這樣：Name         Day  CustomerA    Monday  CustomerA    Thursday  CustomerB    Tuesday  CustomerB    Friday  CustomerC    Wednesday  CustomerC    Saturday  我想有一個返回如下結(jié)果的查詢：Name         ALLDays  CustomerA    Monday, Thursday  CustomerB    Tuesday, Friday  CustomerC    Wednesday, Saturday  謝謝。
查看完整描述

3 回答

?
小怪獸愛吃肉

TA貢獻(xiàn)1852條經(jīng)驗 獲得超1個贊

由于這只是一小部分選項，另一種沒有VBA的方法是設(shè)置一系列IIF語句并連接結(jié)果。


SELECT name, 

   IIF(SUM(IIF(day = "Monday",1,0)) >0, "Monday, ") & 

   IIF(SUM(IIF(day = "Tuesday",1,0)) >0, "Tuesday, ") & 

   IIF(SUM(IIF(day = "Wednesday",1,0)) >0, "Wednesday, ") & 

   IIF(SUM(IIF(day = "Thursday",1,0)) >0, "Thursday, ") &

   IIF(SUM(IIF(day = "Friday",1,0)) >0, "Friday, ") &

   IIF(SUM(IIF(day = "Saturday",1,0)) >0, "Saturday, ") &

   IIF(SUM(IIF(day = "Sunday",1,0)) >0, "Sunday, ") AS AllDays

FROM Table1

GROUP BY name

如果你是一個完美主義者，你甚至可以擺脫這樣的最后一個逗號


SELECT name, 

LEFT(

   IIF(SUM(IIF(day = "Monday",1,0)) >0, "Monday, ") & 

   IIF(SUM(IIF(day = "Tuesday",1,0)) >0, "Tuesday, ") & 

   IIF(SUM(IIF(day = "Wednesday",1,0)) >0, "Wednesday, ") & 

   IIF(SUM(IIF(day = "Thursday",1,0)) >0, "Thursday, ") &

   IIF(SUM(IIF(day = "Friday",1,0)) >0, "Friday, ") &

   IIF(SUM(IIF(day = "Saturday",1,0)) >0, "Saturday, ") &

   IIF(SUM(IIF(day = "Sunday",1,0)) >0, "Sunday, "),

LEN(

   IIF(SUM(IIF(day = "Monday",1,0)) >0, "Monday, ") & 

   IIF(SUM(IIF(day = "Tuesday",1,0)) >0, "Tuesday, ") & 

   IIF(SUM(IIF(day = "Wednesday",1,0)) >0, "Wednesday, ") & 

   IIF(SUM(IIF(day = "Thursday",1,0)) >0, "Thursday, ") &

   IIF(SUM(IIF(day = "Friday",1,0)) >0, "Friday, ") &

   IIF(SUM(IIF(day = "Saturday",1,0)) >0, "Saturday, ") &

   IIF(SUM(IIF(day = "Sunday",1,0)) >0, "Sunday, ")

) - 2

)

AS AllDays

FROM Table1

GROUP BY name

您還可以考慮將它們保存在單獨的列中，因為如果從另一個列訪問此查詢，這可能會更有用。例如，通過這種方式查找只有星期二的實例會更容易。就像是：


SELECT name, 

IIF(SUM(IIF(day = "Monday",1,0)) >0, "Monday") AS Monday,  

IIF(SUM(IIF(day = "Tuesday",1,0)) >0, "Tuesday") AS Tuesday,

IIF(SUM(IIF(day = "Wednesday",1,0)) >0, "Wednesday") AS Wednesday,

IIF(SUM(IIF(day = "Thursday",1,0)) >0, "Thursday") AS Thursday,

IIF(SUM(IIF(day = "Friday",1,0)) >0, "Friday") AS Friday,

IIF(SUM(IIF(day = "Saturday",1,0)) >0, "Saturday") AS Saturday,

IIF(SUM(IIF(day = "Sunday",1,0)) >0, "Sunday") AS Sunday

FROM Table1

GROUP BY name


查看完整回答
反對 回復(fù) 2019-09-03
  • 3 回答
  • 0 關(guān)注
  • 734 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

 幫助反饋 APP下載

慕課網(wǎng)APP
您的移動學(xué)習(xí)伙伴

 公眾號

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號