I've gone brain dead please help


I have a table calles weeks with the following fields
Month,Month Start,Month End, Year

Month is set as text type while all the others are set as Integer Type.

I'm trying to extract the month where a variable called wks (integer type) is > = month start and <= month end and yrs = year(yrs set as integer type as well). I have the following SQL at the moment

I have to use the Val otherwise i get a data type mismatch error though why I can't work out.

using the sql as it is know I get the wrong month returned for example it returns the month february when the start month =6 and the end month = 9 for that month but wks = 35.

[/QUOTE]
Code:
 Set RstWk = Dbs.OpenRecordset("select * from weeks where Val([month start]) >= '" & wks & "' and val([month end]) <= '" & wks & "'") 'and val([year]) = '" & yrs & "'")