按小时查询问题

lyhstud

请教版主:

   如何在每天的数据中按班次0~8小时、9-16小时、17-24小时统计生产量。第二：如何按班次0~8小时、9-16小时、17-24小时统计汇总各品种的总数。拜托，请帮邦忙．

stud

或者换一种说法:

    如何将时:分:秒如13:26:32这样按日期时间顺序排列的许多数据中的时间字段只显示小时数?

[此贴子已经被作者于2007-7-4 18:44:34编辑过]

一点通

一人双号?一个是男的,另一个冒充女的

[此贴子已经被作者于2007-7-4 19:05:16编辑过]

stud

版主是两个人,请回答问题吧!真的很急.

一点通

做一个简单的例子,然后上传,这样才不会浪费别人的时间

stud

好上传一个，您一定要帮我呀。

stud

一点通

SELECT Sheet1.客户单位, Sheet1.年份, IIf([时间]>#12/30/1899# And [时间]<#12/30/1899 8:0:0#,"零时班",IIf([时间]>#12/30/1899 7:59:59# And [时间]<#12/30/1899 16:0:0#,"日班","夜班")) AS 班别, Sum(Sheet1.发瓶数) AS 发瓶数之Sum, Sum(Sheet1.回瓶数) AS 回瓶数之Sum, Sum(Sheet1.自备瓶数) AS 自备瓶数之Sum, Sum(Sheet1.空瓶数) AS 空瓶数之Sum, Sum(Sheet1.退满瓶数) AS 退满瓶数之Sum, Sum(Sheet1.待检瓶数) AS 待检瓶数之Sum, Sum(Sheet1.送检瓶数) AS 送检瓶数之Sum, Sum(Sheet1.待修瓶数) AS 待修瓶数之Sum, Sum(Sheet1.报废瓶数) AS 报废瓶数之Sum, Sum(Sheet1.丢失瓶数) AS 丢失瓶数之Sum, Sum(Sheet1.走车瓶数) AS 走车瓶数之Sum, Sum(Sheet1.坏瓶阀数) AS 坏瓶阀数之Sum, Sum(Sheet1.少瓶阀数) AS 少瓶阀数之Sum, Sum(Sheet1.少瓶圈数) AS 少瓶圈数之Sum, Sum(Sheet1.少配件数) AS 少配件数之Sum
FROM Sheet1
GROUP BY Sheet1.客户单位, Sheet1.年份, IIf([时间]>#12/30/1899# And [时间]<#12/30/1899 8:0:0#,"零时班",IIf([时间]>#12/30/1899 7:59:59# And [时间]<#12/30/1899 16:0:0#,"日班","夜班"));

stud

版主这么快都写完了，真的很佩服。再次表示感谢，顺祝您越长越帅。

goto2008

学习