i have 2 crosstab queries that i need to filter by the [year] control on a form. what i need to do is be able to enter 2002 into the text box and pust the Sales By Site Report button and it will pul up the report for that year.
i have 2 crosstab quires, and a select query based on those 2 queries. this is what the report data comes from.
under Expr1: Format([Date], "mmm"), a group by field in the crosstab queries, i have been trying this
Between 1/1/[Forms].[_frmReports].[Year] And 12/31/[Forms].[_frmReports].[Year] in the Criteria field. it does not quite work.

does anyone know how to do what i'm trying to do?