Sick Leave count

  • Thread starter Thread starter Tia
  • Start date Start date
T

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
 
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
Click to expand...
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"));
Click to expand...
Please help- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

??????????????????????????????????
 
Back
Top