How to use make-table parameter value appear in report

[Terri]

I have a make-take query that gathers reports based upon
specific date ranges. In the criteria field in the query
I have "Between [Enter Start Date: (Example: 08/29/04)]
And [Enter End Date: (Example: 08/29/04)]". This works
fine. The records in the specific date range make a new
table. I then use this new table to create a report.
This works fine. What I would like to do is have the
date range appear in the report in a text box so the user
will know what dates are covered on the report. Is there
a way to do this without having to type the dates in two
separate times? Thanks

 

[Nikos Yannacopoulos]

Terri,

An nice and easy way to do it is to use a form to enter the dates on, and
have both the query and the report read the dates from the form, like:
Between Forms!FormName!txtDateFrom and Forms!FormName!txtDateTo
in the query, and
=Forms!FormName!txtDateFrom
=Forms!FormName!txtDateTo
in the ControlSource property of two textbox controls in the report.
Moreover, you can add a command button on the form which runs the macro(?)
which runs the make-table query and opens the report, or you can do the same
directy through code.
Q: is the table for the report necessary? Why not just use the query
directly and save on unnecessary database bloat?

HTH,
Nikos