What I need in the Report

[Scadadude]

I am running a report based off a query and my query prompts me for a First Date and End Date for it to know what time frame I am looking for. How can I show on my report the dates that I put in for the query. It isnt a constant date so I am puzzled.

Thanks

Scadadude

 

[Kiwiman]

Howzit

Run the report from a form. On this form put two text boxes (or combo boxes if you want to select the dates from a table) that will represent your From and To dates.

In your query where you have the parameters asking for the dates, link them to the two text boxes - something like

 between [Forms]![yourform]![yourFromtextbox] and [Forms]![yourform]![yourTotextbox]

Your report can then reference the dates on this form as well. Your text box in your report will have a control source that will look something like:

="between " &[Forms]![yourform]![yourFromtextbox] & " and " & [Forms]![yourform]![yourTotextbox]

 

[pbaldy]

Presuming you're using something like

[Enter start date]

in the query, you can simply have a textbox with the exact same text:

=[Enter start date]

You can also create something like:

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