Filter a report with unbound text box

[Tskutnik]

Easiest question ever I am sure.

I have a report [Report1] that gets its data from a query [Query1].
On [Report1] there is an unbound text box [EnterEndDate] that I want to use as a filter for the report criteria, and have it filter the report to show every report row with the value in the [EndDate] field greater than what the user entered in [EnterEndDate].

There is no need to save the value used in [EnterEndDate]. It will be entered after the report is run and changed on demand while the report is open for the user to see different date ranges.


Thanks

 

[KSReynolds]

I would think that you have to put the > [Enter End Date] criteria on the date field in the query that controls the report, not the unbound field. If it is unbound, how will it know how to filter the records?

 

[Tskutnik]

Thanks. I'm trying to set the parameter from the report and not from the query directly.
I could be completely wrong with my Unbound approach.
Bottom line I guess, how can I use a text field in a report to dynamically filter the report results?