hello:
i want to know if its possible to create a subform with the following layout:
january 2001
monday tuesday ....
1 2
shift 1 e1 e2
shift 2 e2 e1
all the information is stored in a table: the day of the month, the month, the weekday of THAT day of the month, and e1, e2 (are employees).
i need to put info horizontally (days of week and days of moth) and vertically (employees)
as you can see, its like a crosstab query, but i dont know how to do it.
i want to know if its possible to create a subform with the following layout:
january 2001
monday tuesday ....
1 2
shift 1 e1 e2
shift 2 e2 e1
all the information is stored in a table: the day of the month, the month, the weekday of THAT day of the month, and e1, e2 (are employees).
i need to put info horizontally (days of week and days of moth) and vertically (employees)
as you can see, its like a crosstab query, but i dont know how to do it.