Parameter with Month & Year Criteria

[Huddle]

I have the Field EXP:Month([Insp_Date]) set up with the below parameter in the criteria. This parameter is taken from a form where a date is entered. The problem I have is that the result brings in all years i.e. Oct 2010, Oct 2011, Oct 2012 where I want it to bring in the month and year of the date entered i.e. Oct 2012. How do I add the year in the equation?



(Month([Forms]![Fm_Date_Single_Parameter]![SingleStartDate]))

[pbaldy]

Do the same thing but use the Year() function.

[Huddle]

Works great...Thanks

[pbaldy]

No problem.