Add a calculated field to the query for each parameter:
FirstParameter: [ActualTextOfParameter]
etc.
So the SQL statement, generically, would look like this:
SELECT Field1, Field2, [ActualTextOfParameter] AS FirstParameter
FROM TableName
WHERE Field1 = [ActualTextOfParameter];
Then bind a textbox to the FirstParameter field from the query.
Alternatively, use a form to run the report, and have a textbox on the form
that contains the parameter value. Then let the query and the report both
read the value from the form's textbox control.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
freddyvet said:
I have an Access2007 report. Its data source is a query which has
parameters.
So the user opens the report and the query asks for the dates to be
included.
How can I pass these dates back to the report to appear in the header?