Sick Leave count

[Tia]

DEAR ALL,
I have a list of attendance along with a working code that includes
working day , sick,annual leave
I want to know how much each employee has as sick leave i have used
this query but i am geting data mispatch

SELECT [JANUARY 25-12/24-01 ATTENDANCE].ID, [JANUARY 25-12/24-01
ATTENDANCE].Employee, [JANUARY 25-12/24-01 ATTENDANCE].[Work Code],
Count([JANUARY 25-12/24-01 ATTENDANCE].[Work Code]) AS [CountOfWork
Code]
FROM [JANUARY 25-12/24-01 ATTENDANCE]
GROUP BY [JANUARY 25-12/24-01 ATTENDANCE].ID, [JANUARY 25-12/24-01
ATTENDANCE].Employee, [JANUARY 25-12/24-01 ATTENDANCE].[Work Code]
HAVING ((([JANUARY 25-12/24-01 ATTENDANCE].[Work Code])="sick"));

Please help

 

[James Ford]

mmmmm.....?

 

[Tia]

DEAR ALL,
I have a list of attendance along with a working code that includes
working day , sick,annual leave
I want to know how much each employee has as sick leave i have used
this query but i am geting data mispatch

SELECT [JANUARY 25-12/24-01 ATTENDANCE].ID, [JANUARY 25-12/24-01
ATTENDANCE].Employee, [JANUARY 25-12/24-01 ATTENDANCE].[Work Code],
Count([JANUARY 25-12/24-01 ATTENDANCE].[Work Code]) AS [CountOfWork
Code]
FROM [JANUARY 25-12/24-01 ATTENDANCE]
GROUP BY [JANUARY 25-12/24-01 ATTENDANCE].ID, [JANUARY 25-12/24-01
ATTENDANCE].Employee, [JANUARY 25-12/24-01 ATTENDANCE].[Work Code]
HAVING ((([JANUARY 25-12/24-01 ATTENDANCE].[Work Code])="sick"));

Please help- Hide quoted text -

- Show quoted text -

??????????????????????????????????