I have this query

QRY = "SELECT * FROM tblMain_BV WHERE ([BV] BETWEEN cint(" & tbox_BV_min & ") AND cint(" & tbox_BV_max & ")) ORDER BY [BV];"

the problem is that I assign it to the record source of a subform but it lists only all the occurances of the next occuring value from the low end.

eg. i enter 0 and 12 as my boundries

there are no 0's or 1's but 10 2's and 5 7's. Only the 2's are returned not the fives.

i'm baffled!!!!!!! Any thoughts??????

Is [BV] defined as a number in your source table? If not, this might do it.

QRY = "SELECT * FROM tblMain_BV WHERE (cint([BV]) BETWEEN cint(" & tbox_BV_min & ") AND cint(" & tbox_BV_max & ")) ORDER BY [BV];"

~Abby