Hi all ,
New here struggling to get a filter to work with Access 2003. Here's what I have
A Query (Called QRY_COST_BY_PERIOD containing data (including a column for year(called YEAR))
A Report with a bar chart in laid out how I need it (Called TRANSPORT_COST_BY_PERIOD_TEMP_REJECT)
A Form with 2 text boxes (YEAR_START and YEAR_END) and a command button with a Macro assigned (an OpenReport Macro). The Macro is as follows:
Code:
[QRY_COST_BY_PERIOD]![YEAR]>[Forms]![FRM_TEMPREJECTS_BY_PERIOD_FILTER]![YEAR_START]<[Forms]![FRM_TEMPREJECTS_BY_PERIOD_FILTER]![YEAR_END]
Basically when I type in a year to year say 2013 and 2015 it opens my report with the chart, but the chart still shows all years and not just the filtered ones I have asked for.
I basically want the query to filter to the year range I type in and then open the report with the new query. I cant get my head around what I am missing?
Any help would be majorly appreciated!
Thanks!
Nick