Crosstab query report error

[Derrick T. Davidson]

I have created a crosstab query to compare monthly exchange rates, and it looks just what I wanted it looks something like this:

Month No	Month	2013	2014	2015
1	January	66.89	71.45	65.64
2	February	67.34	68.37
3	March	68.00	69.03
4	April	67.89	68.92
5	May	71.09	72.12
6	June	69.54	70.57
7	July	69.66	70.69
8	August	69.00	70.03
9	September	70.45	71.48
10	October	70.00	71.03
11	November	65.21	66.24
12	December	66.66	67.69

My problem is when I try to make a report I get the error message "Does not recognize [qryExRate].[MonthNo] as a valid field name or expression" ( [qryExRate] is the query I use in the crosstab named qxtbExRate )

I need the month number to list the months in order Jan through Dec.

Am I doing something wrong or is this not possible?

[June7]

Are you use the MonthNo field as sort criteria in report design?

[Derrick T. Davidson]

Yes otherwise the months show in alpha order not consecutive jan, feb etc.

[June7]

I don't use CROSSTABS so not very familiar with their quirks. I do know filter criteria require defined parameters. Maybe the same for sort criteria. Review http://allenbrowne.com/ser-67.html