syntax error (missing operator)

[Wan]

I have try change (WHERE bil "= ) so many times. I search forum that have same problem but didn't find what's the problems.

<%
Dim nilai, catatan, cadangan, status
Dim sConnString, conn, sSQL
nilai = Request.Form("hiddenfield")
catatan = Request.Form("S1")
cadangan = Request.Form("D1")
status = Request.Form("C1")

sConnString = "PROVIDER = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = "& Server.MapPath("sistem.mdb")
sSQL = "UPDATE mohon SET "
sSQL = sSQL & "catatan = '" & catatan & "',"
sSQL = sSQL & "cadangan = '" & cadangan & "',"
sSQL = sSQL & "lulus = '" & status & "'"
sSQL = sSQL & " WHERE Bil = " & nilai

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open(sConnString)
conn.execute(sSQL)
conn.Close
Set conn = Nothing
%>

Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Bil ='.
line 22 'at sSQL = sSQL & " WHERE Bil = " & nilai

I hope any members here can help me...!

[kgh]

is it...

WHERE Bil = '" & nilai & "'"

Notice the '