Displaying crosstab query results on a  Access form

PARAMETERS [Forms]![frmReports]![txtStartDate] DateTime, [Forms]![frmReports]![txtEndDate] DateTime;
You can't use a pass-through query or a non-fixed-column crosstab query as a record source for a subform or subreport. 
 
SELECT QuotesFile.[Created By User Type], Count(QuotesFile.[Created By User Type]) AS [Total Quotes]
FROM QuotesFile
WHERE (((QuotesFile.[Created By Source]) In ('CSCC','IQT','SCC')) And ((QuotesFile.[Creation Date]) Between Forms!frmReports!txtStartDate And Forms!frmReports!txtEndDate))
GROUP BY QuotesFile.[Created By User Type]
PIVOT QuotesFile.[Created By Source];
 
This is the secont query
 
PARAMETERS [Forms].[frmReports].[txtStartDate] DateTime, [Forms].[frmReports].[txtEndDate] DateTime;
TRANSFORM Count(QuotesFile.[Created By User Partner]) AS CountOfID
SELECT QuotesFile.[Created By User Partner] AS Partner, Count(QuotesFile.[Created By User Partner]) AS [Total Of ID]
FROM QuotesFile
WHERE (((QuotesFile.[Created By Source]) In ('CSCC','IQT','SCC')) And ((QuotesFile.[Creation Date]) Between Forms!frmReports!txtStartDate And Forms!frmReports!txtEndDate))
GROUP BY QuotesFile.[Created By User Partner]
PIVOT QuotesFile.[Created By Source];
 
 
Third query
 
SELECT (CSCC_Count/(CSCC_Count+IQT_Count+SCC_Count) )*100
FROM [SELECT QuotesFile.[Created By Source], SUM( CASE WHEN QuotesFile.[Created By Source] = 'CSCC' THEN 1 ELSE 0 END) AS CSCC_Count,
SUM( CASE WHEN QuotesFile.[Created By Source] = 'IQT' THEN 1 ELSE 0 END) AS IQT_Count,
SUM( CASE WHEN QuotesFile.[Created By Source] = 'SCC' THEN 1 ELSE 0 END) AS SCC_Count
FROM QuotesFile
WHERE (((QuotesFile.[Created By Source]) In ('IQT','CSCC','SCC')) AND (([QuotesFile].[Creation  Date]) Between '11/1/2007' And '11/30/2007'))
GROUP BY QuotesFile.[Created By Source]
]. AS [%$##@_Alias];