Entering criteria into a Crosstab query (1 Viewer)

[Andy Allan]

I started out with a Select query and converted it into a Crosstab query. Unfortunately the criteria now have to be hardcoded because the crosstab query does not appear to accept user input criteria eg: [Please input account number]. It brings back a SQL jet engine error, whereas with a select query it brings up a pop up input screen which enables the user to enter criteria when they run a query. How can I enable the criteria to be input when a cross tab query is run ?

 

[Pat Hartman]

Crosstabs can take parameters the same as select queries except that the parameters need to be explicitly defined whereas the select query will work either way.

In the QBE grid right-click on the grey background and choose parameters from the menu. Make sure you type the names here EXACTLY as they appear in the query. It is best to cut and paste to be sure.