update a number in Access

[weee]

When I'm updating a number it should be in '?

like that:
SQL = "UPDATE tstTBL SET numOfProducts='" & numOfProducts & "' WHERE id=" & companyId

Or without?

[buntine]

If you have defined that field as a number in your Access table, then you should not use single quotes.

Strings, on the otherhand, need single quotes.

Dates and times use the # character.

Regards.

[weee]

!