P
pierre
Hi all,
I have 3 fields, employeNb, date and hours
and i want to fing the overtimes hours using somthing like
SELECT INV.empno, Sum(INV.hr) AS SommeDehr
FROM INV
GROUP BY INV.empno
HAVING (((INV.DATE_INV) Between #1/1/2005# And #1/25/2005#));
But, I have an error message regarding agregate function.
In the employe field i put group
In the hour fiel i put sum
In the date field i put expression
What is wrong there?
I want one record for each employe with his total ttime for the date range.
I would like to do that in only one query since i use it as the
recordsource of a form
The user select a date range on a calendar and the form should
display hte total time for each employe.
I dont know how to do that with a query on top of another one.
regards,
Pierre
I have 3 fields, employeNb, date and hours
and i want to fing the overtimes hours using somthing like
SELECT INV.empno, Sum(INV.hr) AS SommeDehr
FROM INV
GROUP BY INV.empno
HAVING (((INV.DATE_INV) Between #1/1/2005# And #1/25/2005#));
But, I have an error message regarding agregate function.
In the employe field i put group
In the hour fiel i put sum
In the date field i put expression
What is wrong there?
I want one record for each employe with his total ttime for the date range.
I would like to do that in only one query since i use it as the
recordsource of a form
The user select a date range on a calendar and the form should
display hte total time for each employe.
I dont know how to do that with a query on top of another one.
regards,
Pierre