How to Query a SQL table with Months Range

can you please check this link

http://stackoverflow.com/questions/10416266/how-to-compare-date-month-year-with-another-date-month-year

thank you Bhushan, i tried the script from the link you sent to me, the new challenge is, most of the field did no reflect. We then use the SELECT statement as below:

this worked but some months where missing from the result. example : Feburary 2015, Feburary 2016

I will appreciate any help from you in this regard

SELECT column_name(s)

FROM table_name

WHERE column_name BETWEEN value1 AND value2;

SELECT * FROM Orders

WHERE OrderDate BETWEEN #07/04/1996# AND #07/09/1996#;