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.
 
Thanks Duane...this worked well.

Duane Hookom said:
Consider abandoning all parameter prompts for this and other reasons. Use
references to controls on forms.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query In Report Title 3
print a date range from parameter query on a report header? 2
How do I print query parameters on the report? 2
Rerun query 2
Custom Parameter Dialogs for Reports 2
reports requiring parameters which shouldn't 2
Printing parameters in reports 1
Parameter Query and reports 3

Back
Top