关于ACCESS，请大侠帮帮忙

夨憶

关系在附件里，问题是这个:请在员工工时表增加日期字段，任意输入日期并按季度统计员工工时,格式为:员工代码,姓名,部门,工时.              就是不是很会，请大家帮个忙啊，谢谢了

咱家是猫

请上传库附件

夨憶

已上传，谢谢了啊

amazeyeli

[code=sql]select
        a.[employee id],b.name,c.[department name],a.hours_sum
from
(
(
select [employee id],SUM([hours]) as hours_sum
from [job assignment]
group by [employee id],DATEPART("q",[date])
) as a
inner join employee as b
on a.[employee id]=b.[employee id]
)
inner join department as c
on b.[department num]=c.[department num]
[/code]

amazeyeli

字段不建议带空格
请使用非运算字符代替,例如_