Help with Label in Report Header

[taimysho0]

Hello, i have a report that is based off a query. This query is composed of one other query (lets call this query 1 and the query of the report query 2). The criteria for query 1 is Between [DateTo] and [DateFrom]. There is no criteria for Query 2.


I want the header of my report to display whatever the date range the user inputs when the criteria pops up asking for a date range. In this format:


ex: January 1, 2012 - January 31, 2012



Thanks!

[June7]

User input in response to query parameter prompts in criteria row are not available for reference. Have a form where user inputs dates in textboxes. Query refers to the textboxes for criteria input. A textbox in report header can have ControlSource that refers to the form controls. Requires form to remain open when report runs.

[taimysho0]

is tehre a way to do this without a form? an alternate solution? thanks

[June7]

Anything else requires more code. I never use query parameter prompts, I use forms. Can't validate user entry in query prompts. They can enter anything and the report will still execute, even if the entry was bad. Just means lots of frustration for users.

[taimysho0]

i tried referring to the variable in the criteria, and put that on my report and it works.


ex:

between (date from) and (date to)


and on report i put textboxes with these two variables and it shows up

thanks for help though

[June7]

Not understanding. You used a form to enter criteria and report refers to form?