How do I display Query parameters on a Report?

[JRG0620]

I have created a report using a Query as the record source. Within the query, the user must enter a 'start date' and 'end date'. The query executes and the report displays the proper data. The user now wants the 'start date' and 'end date' to display in the report heading. How do I do this. Thanks for any/all help.

 

[pbaldy]

A textbox with a control source of:

="Data from " & [Enter start date] & " to " & [Enter end date]

note that the text used in the brackets must match exactly the text used in the query.

 

[Uncle Gizmo]

This is a recurring question and I'm if you search the forum you will find the answer, however if you have some difficulty performing a search then re post here.

If you follow this link, it offers you a way of searching just this forum.

 

[JRG0620]

Not sure of the syntax. I am creating report xyz and the query that I am using is abc.
The query's sql is:
SELECT FA1MAIN.Proj, FA1MAIN.AnalDate, FA1MAIN.Analcost, FA1MAIN.Qualcost, FA1MAIN.Qual_non_rf, FA1MAIN.Attach_Interest, FA2ANAL.Construction_cost, FA2ANAL.Design_cost, FA2ANAL.Other_cost, FA2ANAL.Attach_interest
FROM FA1MAIN INNER JOIN FA2ANAL ON FA1MAIN.Proj = FA2ANAL.Project
WHERE (((FA1MAIN.AnalDate) Between [Start Date] And [End Date]));

I want to display [Start Date] and [End Date] on the report

 

[pbaldy]

Read post 2 and adjust the bracketed text to match yours.