J
jean.ulrich
Hi
I have 2 tables
One is an employe's table (TB-Employees) and the second is a time
sheet table (TB-TimeSheet) as I record worked hours for each employee
and every day.
As employees have not start working on the same day, I would like a
query that show for each employee tha lowest date (date I have start
record working hours for each one)
The relation between the 2 tables is [EmpNo]
example:
employee N°1 records for the 1, 2, 3, 4, 5, 6 .....june
employee N°2 records for the 6, 7, 8, .....june
employee N°3 records for the 1, 2, 3 .....september
Result I want
Employee N°1 1 june
Employee N°2 6 june
Employee N°3 1 september
So I should have a query including the 2 tables with [EmpNo] as a
relation and a calculated field that should use a fonction
thanks
I have 2 tables
One is an employe's table (TB-Employees) and the second is a time
sheet table (TB-TimeSheet) as I record worked hours for each employee
and every day.
As employees have not start working on the same day, I would like a
query that show for each employee tha lowest date (date I have start
record working hours for each one)
The relation between the 2 tables is [EmpNo]
example:
employee N°1 records for the 1, 2, 3, 4, 5, 6 .....june
employee N°2 records for the 6, 7, 8, .....june
employee N°3 records for the 1, 2, 3 .....september
Result I want
Employee N°1 1 june
Employee N°2 6 june
Employee N°3 1 september
So I should have a query including the 2 tables with [EmpNo] as a
relation and a calculated field that should use a fonction
thanks