Creating input forms for queries?

[Brujeria5]

Let me apologize ahead of time for the n00b incoherence. So I'm not sure how to explain what I want here...I'm basically looking for the easiest way for a complete non-techie to perform a query for running a report. That is, can one create a form that will prompt them to enter the values by which the query will run? And if so, what is the way to set that up? Scenario looks like this:

• I have a simple table that contains item name and date sold.
• The user wants to run a regular report that will come back with all items sold in the last 5 years, but needs the ability to query for different year amounts (i.e. sales in last 2, 7, 10 years, etc.)
• user is EXTREME technical novice - needs basic fill-in-blank or push button interface.

I'm envisioning using the switchboard to give them choices on input/editing/reporting, and attaching a sort of query input form to it. Does that make sense? I know this is probably some extremely simple thing, but for some reason I can't seem to make this work in my head. All suggestions greatly appreciated!!!

[SoftwareMatters]

Create a form (call it ReportForm) with a button that opens the report and a text box (called FromDate) where the user can enter a date.
In the report query in the criteria for the date field put a reference back to the form like this:
>= Forms!ReportForm!FromDate
Now the report will show records starting from whatever date is entered in to the date field.