[問題] access查詢
軟體:access
版本:2007
設立一個查詢 ，sql如下：
SELECT [跌倒二次以上人數 查詢].月份, Count([跌倒二次以上人數 查詢].病歷號碼)
AS 病歷號碼之筆數1
FROM [跌倒二次以上人數 查詢]
GROUP BY [跌倒二次以上人數 查詢].月份;
想請問一下如果想要就算某月沒有發生蹤倒二次以上的人數
也想要在查詢裡是可以出現月份
年 月 筆數
10301 0
10302 2
10303 6
是否有辦法可以辦到呢？謝謝~
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 163.15.161.248
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1411033926.A.E27.html
→
09/18 18:40, , 1F
09/18 18:40, 1F
→
09/18 23:19, , 2F
09/18 23:19, 2F
→
09/19 09:34, , 3F
09/19 09:34, 3F
→
09/19 13:44, , 4F
09/19 13:44, 4F
→
09/19 13:44, , 5F
09/19 13:44, 5F
→
09/19 15:49, , 6F
09/19 15:49, 6F
→
09/22 08:07, , 7F
09/22 08:07, 7F
→
09/22 08:07, , 8F
09/22 08:07, 8F
→
09/22 08:08, , 9F
09/22 08:08, 9F
→
09/22 08:21, , 10F
09/22 08:21, 10F
→
09/22 08:21, , 11F
09/22 08:21, 11F
→
09/22 15:42, , 12F
09/22 15:42, 12F
→
09/22 15:44, , 13F
09/22 15:44, 13F
→
09/22 15:45, , 14F
09/22 15:45, 14F
→
09/22 19:57, , 15F
09/22 19:57, 15F
→
09/22 20:16, , 16F
09/22 20:16, 16F
→
09/22 20:31, , 17F
09/22 20:31, 17F
→
09/22 20:31, , 18F
09/22 20:31, 18F
→
09/22 20:32, , 19F
09/22 20:32, 19F
→
09/22 20:56, , 20F
09/22 20:56, 20F
→
09/22 20:57, , 21F
09/22 20:57, 21F
→
09/22 21:01, , 22F
09/22 21:01, 22F
→
09/22 23:56, , 23F
09/22 23:56, 23F
→
09/22 23:56, , 24F
09/22 23:56, 24F
→
09/23 09:47, , 25F
09/23 09:47, 25F
→
09/23 09:49, , 26F
09/23 09:49, 26F
→
09/23 15:00, , 27F
09/23 15:00, 27F
→
09/23 15:00, , 28F
09/23 15:00, 28F
→
09/23 18:34, , 29F
09/23 18:34, 29F
討論串 (同標題文章)
Office 近期熱門文章
PTT數位生活區 即時熱門文章
