Parameters on a report

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

Guest

I have a parameter query (Between[Enter Start Date] and [Enter End Date])
that creates a table. I use the table for a report. Is there a way to
capture the paramerters and add them to the report.
 
Since the parameters are gone once you create the table, you could only use
values in your report that are stored some place. I would use references to
controls on a form and then use the control values in your report.

You could also use Min([YourDateField]) and Max([YourDateField]) if they
consistantly matched your start and end dates.
 
or better yet..... here

To do this place 2 text boxes with their labels in the report header

Go to the properties of the text box and in the control source enter the
first parameter (example) =[Enter Start Date].
Do the same with the second text box =[Enter End Date]
And in the labels, just have them worded the way you want it to appear in
the report.

KB
 
I think you missed the part of the original post that suggested the query
was a make-table query and the report was based on the "made" table and not
the query. Once the query has been run and closed, the values are no longer
available to the report since it doesn't use the query as the record source.
 
Back
Top