Between Month Criteria Query

[Rizkidwip]

Hi..
I have 3 fields of query [id], [date], and MonthOfDate:month([date]). My Date's record contain complete array of month (so it is month 1 - 12). I try to filter MonthOfDate by criteria like:
>3 it work
>=3 and <=12 it work
but it didn't work perfect when i try to insert those value from a text box control form by this code
<=forms![form1].[txt_end]
if i input 12 on [txt_end] then run query, it display records from month=10 until month = 12

ot if with this codes:
>=forms![form1].[txt_start] and <=forms![form1].[txt_end]
while i insert 1 for my [txt_start] and 12 for my[txt_end], the records display from month=1 until month=9

how to solve that?


thanks in advance

[lfpm062010]

It looks like it is doing the text comparision not numbers.

Try CInt(Textbox),

<=CInt(forms![form1].[txt_end])

[Rizkidwip]

I insert cint() but still the same,it's like my access think that month 10-12 is smaller than other. I try add another textbox and try to calculate txt_end - txt_start on it. It's normal as it should,how then?

[Rizkidwip]

I just attached my sample db hopefully anyone can help easily
thanks

[Bob Fitz]

Can you post a copy in A2003 mdb format

[Rizkidwip]

Sure Bob Flitz, there it's

[Bob Fitz]

I've had a play with the db you posted. Try this:

[Rizkidwip]

Big thanks Bob Flitz, I'd just missed that step LOL-to use Field1 as my bound (1) rather than field month (2) so Novice I am