select all records under mm/yyyy

[aziz sonnari]

Hi I want to select all records under mm/yyyy from access table
this may code show 0 records where 1200 records
the filed = shorte date

mmonth =format( rs!EffDate,"mm/yyyy")="10/2014"
rs.close
rs.open"select * from Shedual where EffDate=#" & mmonth & "#"
Talroc=rs.recordCount=0

thank you

[Rabbit]

You didn't format the EffDate in your query to the same format as the string you're searching for.