Access Parameter Query

Question

Hello,

Although probably inefficient, I have a report that runs from the results of a Crosstab Query (#2) that is the result of another Crosstab Query (#1) that is the result of a Select Query. I have made the Select Query a Parameter Query but when I run the report, I receive the following...

Can someone assist?

Thanks

Answer 1

In the SELECT query declare the parameter via the query designer interface, or by adding a PARAMETERS clause at the start of the SQL statement, e.g.

PARAMETERS [Enter Main Work Center:] TEXT(50);
SELECT……….etc