How do I get parameters printed on report when query not attached

[Denise D]

I have to create six queries just to get my data manipulated for my report.
The problem is that I have to prompt the user for parameters in the third
query and I need to print those parameters on the sixth report query. Any
suggestions?

 

[Ken Snell \(MVP\)]

Include the parameters as calculated fields in the query, and then bind
controls in the report to those calculated fields:

SELECT T.*, [First Parameter] AS FPar,
[Second Parameter] AS SPar
FROM TableName AS T
WHERE T.FieldName1 = [First Parameter] And
T.FieldName2 = [Second Parameter];

 

[Duane Hookom]

Consider abandoning all parameter prompts for this and other reasons. Use
references to controls on forms.