Criteria in date field

[EVERA]

In the query I am trying to put a criteria in a date field. What I want is to get all the data that fits in one month. Can you please help.
Thanks


PS I use Microsoft access 2010

[June7]

Post your attempted query SQL statement.

Possible WHERE clause:

Format([date field], "yyyymm") = [enter yyyymm criteria]

[EVERA]

Post your attempted query SQL statement.

Possible WHERE clause:

Format([date field], "yyyymm") = [enter yyyymm criteria]

In the criteria I am putting #????-06-??# Where ?? is a wildcard. In this case I want all the record that is June.

[June7]

My suggested criteria is text, not a date. The parameter for my suggestion would be: 201406

I forgot apostrophes.

Format([date field], "yyyymm") = "'" & [enter yyyymm criteria] & "'"

Do you want June for every year?

[EVERA]

My suggested criteria is text, not a date. The parameter for my suggestion would be: 201406

I forgot apostrophes.

Format([date field], "yyyymm") = "'" & [enter yyyymm criteria] & "'"

Do you want June for every year?

That is what I want. I want the month for any year.
thanks

[June7]

This is resolved?