How will the user type in the month? I think you should give them a combo with two columns. Column(0) = 1 - 12, and Column(1) = "January" - "December"
Allow them to select a month, and then add a column in the report called "SelMonth" (for selected month) that is:
Then in the criteria line add this:
When the query opens, it will select the records with a Month with the selected numeric value. You don't have to display the SelMonth column in your results.
That is one way of doing it. With information on buttons to launch the query, or reports or forms to display the query results, I could post other methods.
In this case, Date format won't matter unless this is not a Date column, but a text column. If it is a text column, then you have other issues.
Did that help?