disgruntled
Registered User.
- Local time
- Today, 14:33
- Joined
- Jul 3, 2001
- Messages
- 38
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??????
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??????