I’m having trouble creating a Crosstab Query. What I’m trying to do is be able to print a report that lists students names (rows) with fees that the user has selected from a form across the top. I have a form that the user uses to select the school year they want to print the report for. They select this from a drop down box. I then have a query (Category Breakdown Query) that has [Forms]![frmChoose Year]![cmbSelectSchoolYear] in the criteria for the SchoolYearID. When I run this query, it works fine. But when I run the Crosstab Query I created which pull the fields from the Category Breakdown Query, I keep getting an error saying “The Microsoft Jet database engine does not recognize ‘[Forms]![frmChoose Year]![cmbSelectSchoolYear]’ as a valid field name or expression.” I don’t know why I’m getting this message.
I want to be able to choose the year I want to run the report for, then select the fees I want to show on the report. Can I not do this? Is this not possible?