Crosstab with parameters

[Guest]

If I have a query that is pulling from a table with multiple months worth of
records. I have 2 columns with a "month" number, and a "week" number. My
query then asks which Month you want to view.
I have a pivot table based on this information, but can not seem to export
to excel. So, I have based a Crosstab query on this parameter query.
But it doesn't recognize my "Enter the Month you want to view:" parameter to
filter for a single month.

Any ideas on how I can get my crosstab query to filter for a user selected
parameter?

 

[Duane Hookom]

You must set the data type of the parameter:
Query->Parameters
[Enter the Month you want to view:] Integer