[求助]实现按EmployeeID,按时间段,求ActualHour的和的查询

gxingyang

[求助]实现按EmployeeID,按时间段,求ActualHour的和的查询

表1:labortime



<TABLE  cellSpacing=0 cellPadding=0 width=384 border=0 x:str>

<COLGROUP>

<COL style="WIDTH: 48pt" span=6 width=64>





SerialNo

Date

EmployeeID

PartNo

ActualHour

Description



20

2006-5-15

20093144

11/COH 109 20690000066

1





21

2006-5-17

20093144

11/COH 109 20790000225

0.47





22

2006-5-17

20022330

11/COH 109 20790000225

0.71





23

2006-5-17

20022102

BFM 107 71A0018

0.47





24

2006-5-17

20022102

11/COH 109 20790000225

0.47





26

2006-5-17

20093144

BFM 107 71A002920

0.98





27

2006-5-17

20093144

BFM 107 71A002920

0.2



<TR  height=51>

33

2006-5-17

20093144

BFM 107 71A002920

0.98

<TD class=xl26  width=64 x:str="">

WDLRCZT

先用查询计算出ActualHour的和，再用追加查询把结果追加到表2中

gxingyang

使用了dsum函数,问题搞定了,不过dsum函数的查询条件格式比较繁琐,搞了好久才ok