Wrong result in SQL String

[A Newbie]

I take a long tiem for this but i'm still not get a correct answer the sql
string like this

strSQL = "SELECT Table1.one, Table1.two FROM Table1 WHERE Month([two])=1

I want return most of record with the month = criteria but it only return 1
first record only

I know have some thing wrong but I can't findout so please help me to solved

Thanks again...

 

[A Newbie]

sorry for stupid i'm forget that I use Recordset to open that SQL string