error 3464

[swarv]

Hi all,

I am getting error:

Data type mismatch in criteria expression. (Error 3464)

the code that creates it is:

updateuser2 = "UPDATE entitlement SET Entitlementfld = '" & holidaytotal & "'  WHERE id = '" & usersidnumber & "' AND yearfld = '" & nine & "'"

holidaytotal, usersidnumber and nine are all dim'd as integers.
in the entltement table the data type of the fields are all number.

Has anybody got any ideas as to why this error is popping up?

Thanks

Martin

 

[boblarson]

You don't use quotes around numbers. Change this:
WHERE id = '" & usersidnumber & "' AND yearfld = '" & nine & "'"

to this:
WHERE id = " & usersidnumber & " AND yearfld = " & nine

 

[swarv]

cheers bob

serves me right copying from an insert into statement using strings

cheers again