THanks for that Paul. I have the generic fields set on rpt_Comparison. When looking at the code from Post #3 I see that rst = New ADODB.Recordset and I assume that this is where I place the SQL for my query? I am having difficulties getting my crosstab query to function here. Can you look at my SQL and tell me if anything is wrong? It keeps giving me "error: Syntax Error"
Code:
Set rst = "SELECT tbl_Formulas.BillType, tbl_Formulas.RawMaterial, tbl_Formulas.Input " _FROM tbl_Formulas " _
WHERE (tbl_Formulas.BillType)=[forms]![frm_BulkComparison_Select]![bill1] Or (tbl_Formulas.BillType)=[Forms]![frm_BulkComparison_Select]![bill2] Or " _
(tbl_Formulas.BillType)=[Forms]![frm_BulkComparison_Select]![bill3] AND " _
(tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 1] Or (tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 2] Or " _
(tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 3] Or (tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 4] Or " _
(tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 5] Or (tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 6] Or " _
(tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 7] Or (tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 8] Or " _
(tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 9] Or (tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 10] Or " _
(tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 11] Or (tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 12] Or " _
(tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 13] Or (tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 14] Or " _
(tbl_Formulas.Item)=[Forms]![frm_BulkComparison_Select]![Item 15] AND (tbl_Formulas.BP)=[Forms]![frm_BulkComparison_Select]![BP] " _
GROUP BY tbl_Formulas.BillType, tbl_Formulas.RawMaterial " _
PIVOT tbl_Formulas.Item;"
I copied the code straight from the crosstab query in SQL view. I left out the PARAMETERS and TRANSFORM portions. Should I add those back? I tried adding "& " " to the start of each row as I've done this with all my other SQLs but then I get "error: Type Mismatch"