Thanks in advance for any help. Simple stuff, I'm just stuck.
I have a report Called [Financial Projections] that shows a series of months. I'm trying to filter it while in the Report.
1) I want to add text boxes for FromDate and ToDate so the user can dynamically filter the dates while in the report. I could also use combo boxes with a list of dates instead of text boxes - either way is fine, combo is probably better.
The underlying query's field where the FromDate and ToDate would be applied is called [MonthEnd]
Something like this as criteria in the [MonthEnd] field I'm sure: Between Reports!Financial Projections!FromDate and Reports!Financial Projections!ToDate
I just cant quite get it.
2) I want the values entered in the Report's from FromDate and ToDate to be saved so they are the defaults and applied to the [MonthEnd] field when the when the report is reopened. When the user changes the FromDate or ToDate the new value is then saved, replacing the old.
I have a report Called [Financial Projections] that shows a series of months. I'm trying to filter it while in the Report.
1) I want to add text boxes for FromDate and ToDate so the user can dynamically filter the dates while in the report. I could also use combo boxes with a list of dates instead of text boxes - either way is fine, combo is probably better.
The underlying query's field where the FromDate and ToDate would be applied is called [MonthEnd]
Something like this as criteria in the [MonthEnd] field I'm sure: Between Reports!Financial Projections!FromDate and Reports!Financial Projections!ToDate
I just cant quite get it.
2) I want the values entered in the Report's from FromDate and ToDate to be saved so they are the defaults and applied to the [MonthEnd] field when the when the report is reopened. When the user changes the FromDate or ToDate the new value is then saved, replacing the old.
