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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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];
 
Consider abandoning all parameter prompts for this and other reasons. Use
references to controls on forms.
 
Back
Top