Parameter in Cross tab query???

[gard0128]

Is there a way to use a parameter in a cross tab query?

I'd like to simply include the following criteria in the Accounting Month field in my crosstab:

[Enter Current Month]

This works fine in a select query but when I try it in a crosstab, I get the following error:

"The microsoft jet database engine does not recognize [Enter Current Month] as a valid field name or expression."

Any ideas?

 

[Databaseguy]

In the X-Taqb design view, right click, and view the properties dialog box. In that list, there is a parameter property. Fill out the field names and data types as applicable.... Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy