Access Parameter Query

Question

Access Parameter Query

Flinn, Randal J 281

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 accepted by question author

0 additional answers

Your answer

Answer 1

Ken Sheridan 3,546

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

Flinn, Randal J 281 Reputation points

2021-12-13T13:32:27.153+00:00

Thanks @Ken Sheridan ,

Thanks for the response. I am getting the appropriate data!

Evidently, because I am running a query on a query on a query, I am required to enter the Criteria parameter for each query (3 times). I also am generating a chart from the query so it is required again. Is there a better way to automate this process.

Share via

Access Parameter Query

0 additional answers

Your answer