Filter Report Results
Posted on 2011-03-01
Good monring Experts,
I am having a heck of a time with this.
I need to develop a filter that will filter results based on dates. The report I have designed is a preformance report that will show preformance from week to week. On the report i have a feild "ShipDate" that i use to let access recognize when the start date of that product was. I would like the filter to return to me the results of a given time period. So when the user opens the report they are asked what results they are shown.
Can anyone help me do this?
I have a report menu and have a button linked to the report. I would like a box to come up and ask for the filtering criteria: For instance,
After User clicks the report on the menu, a box would come up Start Date- they would enter 2/14/2011 and then the next box would come up End Date: they would type 3/1/2011....
And it would filter the results based on that.
Can anyone help me out with this?