baffled I am????? (1 Viewer)

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??????
 

Abby N

Registered User.
Local time
Today, 14:33
Joined
Aug 22, 2000
Messages
123
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
 

Users who are viewing this thread

Top Bottom