Successfully created a report based off one query that was based off one table.  The report requests one parameter to be entered and I used [Enter Subdivision] as the criteria for the parameter.  All works fine.

 

I want to push this report a little further by including information from 2 crosstab queries that were each based off one table.  When I try to add these 2 queries to my existing query so I can build the report, an error message regarding the parameter comes up - "Database engine does not recognize [Enter Subdivision] as a valid field name or expression".

 

Why won't the parameter work on the new query?