I have 2 crosstab queries, 1 does a Crosstab of referrals by Month, and 1 does it by Quarter. In the Monthly Crosstab I have the field OpenDate as a Where with the Criteria being Between [BegDate] and [EndDate]. This works, the popups come up and ask for the begDate and EndDate with no issues. When I use this same field, OpenDate, as a where in the Quarterly crosstab with the same Criteria I get an error message that "The Microsoft Access database engine does not recognize '[BegDate]' as a valid field name or expression. Any ideas as to why it would work in many other queries and forms and reports, etc. but not this one?