Hai fiends. i have three tables
1)TaskType tbl with fields TaskTypeID(PK), TaskType
2) Places tbl with fields PlaceID(PK), Place
3)Task tbl with fields TaskNo(PK), TaskTypeID(FK), placeID(FK), Task etc.
I want to create a crosstab query to count all records in table3, TaskType as column heading and Place as row heading, query should display all records from TaskType and place tbls. count should show as 0 if no task is done at place and TaskType.
Help me pls.
Thank you in advance.