Crosstab with parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You must set the data type of the parameter:
Query->Parameters
[Enter the Month you want to view:] Integer
 
Back
Top