Hi,
My data is on Sharepoint. I have a simple Crosstab query that works well unless I choose the option Ms Access option "Cache List Data". In that case I get a Type Mismatch error. Any idea what it could be?
Code:TRANSFORM Sum(PivotData.QuoteTotal) AS SumOfQuoteTotal SELECT PivotData.FullName FROM PivotData GROUP BY PivotData.FullName PIVOT PivotData.StatusText;