Trying to create a Report using 2 comboboxes with Month and Year

[eagle1468]

I'm having a problem creating a report using 2 ComboBox -- One For Month and One For Year.



Basically I have Created a Query that shows the Data I want in the Report. Based the Report off the Query. But I need a Form with only 2 ComboBox to make the Query filter the dates by Month and Year.

The Dates in the Query Field "MoveInDate" is formatted mmm/dd/yyyy.

What Criteria would I put in the Query and Where in the query would I put it to pull only those records that the Month and Year match the "MoveInDate"?

I have tried -- [Forms]![ReportSelection]![ReportMonth] And [Forms]![ReportSelection]![ReportYear] in the Criteria under [DetailsQ].[MoveInDate] -- but it just errors out. I put "Like" in front of this Criteria -- No Error But the report shown No Records.....

By the way the ComboBoxes pull from Tables to get their Value.
I have 2 Tables for them. One is "ReportMonthT" with Fields:
"ReportMonthID" = 1-12 & "ReportMonth" = January, February, etc. with the Respective MonthID.
Then I have Table "ReportYear" with Just Years = 2012, 2013, 2014, etc.

Please Help!!!!

Thank you!

[June7]

Try:

WHERE Format([MoveInDate], "yyyymm") = [Forms]![ReportSelection]![ReportYear] & [Forms]![ReportSelection]![ReportMonth]

[eagle1468]

Try:

WHERE Format([MoveInDate], "yyyymm") = [Forms]![ReportSelection]![ReportYear] & [Forms]![ReportSelection]![ReportMonth]

I'm Getting an Error -
The expression you entered contains invalid syntax
You may have entered an operand without an operator

Not sure whats wrong with it!?

[June7]

Post the complete SQL statement for analysis.

[eagle1468]

Post the complete SQL statement for analysis.

I got it! I just had to mess with it. All I had to do was pay attention where I was pulling MoveInDate from -- I for some reason didn't have it set to the right Query.

Thank you VERY VERY Much! you have been a GREAT Help!!!!