Crosstab query

[Judyn2005]

I'm using Access 2003 and was wondering if it is possible to have a paramater selection within a crosstab query so that I wouldn't need to build a new table.

I have a select query that I'm using to build a crosstab query from.

In the select query I'm prompting for a specific quarter using [Which Period?] in the criteria section for the field Period

When I go to run the crosstab it doesn't seem to like the parameter that has been put on the select query and returns a message of "The Microsoft Jet database engine does not recognize '[Which Period?]' as a valid field name or expression."

Any suggestions would be greatly appreciated.

 

[dhookom]

You must specify the data type of your parameter. Select Query->Parameters and enter
[Which Period?] Integer (or whatever)

I would expect your user experience would be much enhanced if they could select or enter the period from a combo box on a form.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]