i got a problem, i have a EPF table in my database. Now, i trying to use the
following code to select the appropriate record out, let say the value for
"CurSalary" entered is "7000.00", then in my table is like this:

from to value
----- ------- -------
6000.01 - 7000.00 = 770
7000.01 - 8000.00 = 840

so it suppose to select the "770"

all my "from", "to", "CurSalary" is declared as Currency.


strSQL = "SELECT EPFEE, EPFER, SOCSOEE, SOCSOER FROM epf, Socso WHERE " _
& "((epf.FROM < " & Format(CurSalary, "#0.00") & ") AND (epf.TO > " & Format(CurSalary,
"#0.00") & ")) " _
& "AND ((Socso.FROM < " & Format(CurSalary, "#0.00") & ") AND (Socso.TO >
" & Format(CurSalary, "#0.00") & "))"


and the problem is, it can't Select the record out, but if i key in "7100.00",
it won't be a problem.