RaffiqEddy
Programmer
Hello, Expert!
I need help on how do I translate this data...
Table "LeaveDetail"
Into this report format...
Using only query statement...
Is this possible??
TIA
Reagrds.
I need help on how do I translate this data...
Table "LeaveDetail"
Code:
StaffNo | StartDate | EndDate | LeaveType |
1 | 01/11/2005 | 04/11/2005 | AL |
2 | 02/11/2005 | 03/11/2005 | MC |
3 | 04/11/2005 | 05/11/2005 | EL |
1 | 10/11/2005 | 11/11/2005 | EL |
Into this report format...
Code:
Month: November
StaffNo |01 |02 |03 |04 |05 |06 |07 |08 |09 |10 |11 |12....
1 |AL |AL |AL |AL | | |EL |EL |
2 | |MC |MC | | |
3 | | | |EL |EL |
Using only query statement...
Is this possible??
TIA
Reagrds.