Strange thing filtering weeknumbers

[quacka]

Something strange:

In my query is a calculated field "Week" (=DatePart("ww",[Datefield])
I want to filter the results.
I used the filter "<=20": I get all week 1 to 20.

But this filter should be flexible. So I changed the filter to: "<=forms!form1!textfield1". In the textfield1 I again filled in 20.
Now I get week 1, 2 and 10 till 20. But not week 3 till 9

I also tried the filter "<=[fill in weeknumber]", but still the incorrect results.

Does someone have a clue?

 

[redneckgeek]

I don't have the solution for you, but the problem is that when
you put <=20 in your criteria, it's being treated as an expression.
When you put your field name from your form in the criteria, it's taking
the value contained in that field and converting it to a string.
Numerically 3<20... but alphabetically 3>20.