hi
Can someone please help me to create a crosstab query. I have a table tblOverzicht with the fields: "name", "Date", "Code". Now I want to create a crosstab with all the dates as column headings and the employee names as row (they may only appear one time) and the Code as value. The goal is to create a view of a whole month.
Thanx
Greetz Serge
Can someone please help me to create a crosstab query. I have a table tblOverzicht with the fields: "name", "Date", "Code". Now I want to create a crosstab with all the dates as column headings and the employee names as row (they may only appear one time) and the Code as value. The goal is to create a view of a whole month.
Thanx
Greetz Serge