I've been getting this error when trying to run a report whose record source is a crosstab query. The query runs fine on its own - I get the error message when attempting to run the report that uses it. Including the code for both query and report below - not too experienced so any help is much appreciated!!
CROSSTAB QUERY:
TRANSFORM Max(IIf([ValType]="UsualValue",[UsualValue],[MaxValue])) AS ByCatVal
SELECT QRY_FEMA_UseLevels_20160429.FEMAno, GRAS3_27PrimNames.PrimaryName
FROM CompULfrm_ValTypeCol, GRAS3_27PrimNames INNER JOIN QRY_FEMA_UseLevels_20160429 ON GRAS3_27PrimNames.[FEMAno] = QRY_FEMA_UseLevels_20160429.FEMAno
GROUP BY QRY_FEMA_UseLevels_20160429.FEMAno, GRAS3_27PrimNames.PrimaryName
PIVOT [ValType] & [FoodCategory];
REPORT RECORD SOURCE:
SELECT CompareUL_UsualMaxVals_ByCat_20160502.FEMAno, CompareUL_UsualMaxVals_ByCat_20160502.PrimaryName, CompareUL_UsualMaxVals_ByCat_20160502.CASno, CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueBaked Goods], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueBeverages, Alcoholic], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueBeverages, Non-alcoholic], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueBreakfast Cereals], CompareUL_UsualMaxVals_ByCat_20160502.MaxValueChee ses, CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueChewing Gum], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueCondiments and Relishes], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueConfections and Frostings], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueEgg Products], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueFats and Oils], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueFish Products], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueFrozen Dairy], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueFruit Ices], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueGelatins and Puddings], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueGranulated Sugar], CompareUL_UsualMaxVals_ByCat_20160502.MaxValueGrav ies, CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueHard Candy], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueImitation Dairy Products], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueInstant Coffee and Tea], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueJams and Jellies], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueMeat Products], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueMilk Products], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueNut Products], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueOther Grains], CompareUL_UsualMaxVals_ByCat_20160502.MaxValuePoul try, CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueProcessed Fruits], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueProcessed Vegetables], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueReconstituted Vegetables], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueSeasonings and Flavors], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueSnack Foods], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueSoft Candy], CompareUL_UsualMaxVals_ByCat_20160502.MaxValueSoup s, CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueSugar Substitutes], CompareUL_UsualMaxVals_ByCat_20160502.[MaxValueSweet Sauces], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueBaked Goods], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueBeverages, Alcoholic], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueBeverages, Non-alcoholic], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueBreakfast Cereals], CompareUL_UsualMaxVals_ByCat_20160502.UsualValueCh eeses, CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueChewing Gum], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueCondiments and Relishes], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueConfections and Frostings], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueEgg Products], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueFats and Oils], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueFish Products], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueFrozen Dairy], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueFruit Ices], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueGelatins and Puddings], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueGranulated Sugar], CompareUL_UsualMaxVals_ByCat_20160502.UsualValueGr avies, CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueHard Candy], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueImitation Dairy Products], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueInstant Coffee and Tea], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueJams and Jellies], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueMeat Products], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueMilk Products], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueNut Products], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueOther Grains], CompareUL_UsualMaxVals_ByCat_20160502.UsualValuePo ultry, CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueProcessed Fruits], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueProcessed Vegetables], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueReconstituted Vegetables], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueSeasonings and Flavors], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueSnack Foods], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueSoft Candy], CompareUL_UsualMaxVals_ByCat_20160502.UsualValueSo ups, CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueSugar Substitutes], CompareUL_UsualMaxVals_ByCat_20160502.[UsualValueSweet Sauces] FROM CompareUL_UsualMaxVals_ByCat_20160502;