G
Gwen
Is it possible to get the results of my crosstable into a make table?
TRANSFORM Count(qTop3_Dates.[SERIAL#]) AS [CountOfSERIAL#]
SELECT qTop3_Dates.Hospital, qTop3_Dates.[Service Type], qTop3_Dates.CLINIC
FROM qTop3_Dates
GROUP BY qTop3_Dates.Hospital, qTop3_Dates.[Service Type], qTop3_Dates.CLINIC
ORDER BY qTop3_Dates.[RUN DATE] DESC
PIVOT qTop3_Dates.[RUN DATE];
I use the crosstab query and another query to create a make table.
The problem is that the crosstab date fields changes.
Please assist.
Thanks
TRANSFORM Count(qTop3_Dates.[SERIAL#]) AS [CountOfSERIAL#]
SELECT qTop3_Dates.Hospital, qTop3_Dates.[Service Type], qTop3_Dates.CLINIC
FROM qTop3_Dates
GROUP BY qTop3_Dates.Hospital, qTop3_Dates.[Service Type], qTop3_Dates.CLINIC
ORDER BY qTop3_Dates.[RUN DATE] DESC
PIVOT qTop3_Dates.[RUN DATE];
I use the crosstab query and another query to create a make table.
The problem is that the crosstab date fields changes.
Please assist.
Thanks