crosstabquery.pdfBoth the joined tables shown contain data from 6 different sites for the company that I work for. Each site contains 20 projects. So these Linked tables contain millions of data. I only need 2 projects from my 1 site. (That's why my project name criteria is Online-Master & Online-Scope).
I created the crosstab query shown since table: KR_DD_KR_TASK_CODE ,column CODE_TYPE needs to be pivoted.
From this Crosstab query I also created an append query which puts all this data into another table called TASK_CODE_APPEND. I also created a delete query for the table. I have this TASK_CODE_APPEND joined with other tables to run work week reports.
Every time I use this access data base I have to refresh (which runs the delete query and then append query in order to have the most up to date data into the TASK_CODE_APPEND table from my Linked ODBC Source table).
The crosstab query takes about a full minute to run. Its slow.
Is there any other option for me to avoid a refresh and speed up the process in pivoting CODE_TYPE for use?
Kind of defeats the purpose of Linked ODBC Source if I have to continuously refresh to update my table.