N
Naz
Hello all
I have a 2 tables that contains the fields
Table1
EmployeID
EmployeeName
Table2
EmployeeID
AbsenceStartDate
AbsenceEndDate
NoOfDaysAbsent
Reason (Sickness, dependecy)
How can i create a query that when i enter a start date and end date i can
get the following output, assuming the date i chose were 01/01/2008 -
07/01/08, the dates need to show even if there is nothing recorded for the
date.
01/01/08 02/01/08 03/01/08
........etc
EmployeeID1 & Name S D
EmployeeID2 & Name S
EmployeeID3 & Name S
I need to be able to output it to excel in the same format which i can do,
but i can't get my head round the query, i've tried a query, a crosstab, but
with no luck
Any help would be greatly appreciated
I have a 2 tables that contains the fields
Table1
EmployeID
EmployeeName
Table2
EmployeeID
AbsenceStartDate
AbsenceEndDate
NoOfDaysAbsent
Reason (Sickness, dependecy)
How can i create a query that when i enter a start date and end date i can
get the following output, assuming the date i chose were 01/01/2008 -
07/01/08, the dates need to show even if there is nothing recorded for the
date.
01/01/08 02/01/08 03/01/08
........etc
EmployeeID1 & Name S D
EmployeeID2 & Name S
EmployeeID3 & Name S
I need to be able to output it to excel in the same format which i can do,
but i can't get my head round the query, i've tried a query, a crosstab, but
with no luck
Any help would be greatly appreciated