Date parameter for Reports

[OrganMan]

Can someone please help?

I have a date filed in my db named dateclosed and another filed named outcome (that includes two different scenarios), how can I create a query and a report so that the user can select either outcome at any given time for say the month of October? Would I have to get the user to enter a start and an end date, if so how do I code for this. Maybe I can create a form and not a query and have this open up a report after the user makes their selection and enters their parameters.

Thanks for the help.

 

[nIGHTmAYOR]

try adding an Expression Field (virtual field) to your query , here is a bogus select statment stating how :

Select [dateclosed] , [outcome] , Month([outcome])  As [B]outcomemonth [/B]From YourTableNameHere;

and then call apon it from open form criteria in like "[outcomemonth]=" & monthnumberhere