Update date field to null in MS Access

[hedidit]

Hi all,

I've got a date field in an ms access database that needs setting back to null after a user has previously entered a date. I'm trying the SQL:

 "UPDATE Tab1 Set D8Complete=null WHERE ID=499"

But am getting the error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10' 

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. 

/risk_db/ResetComplete.asp, line 17

Can anyone help me out with this?

Cheers

 

[gmmastros]

You must have missplled one of the field names (or possibly the table name).

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[hedidit]

Oh dear. How embarrasing!

Sorry for time wasting. The field is spelt D8Completed.

I am a numpty

 

[gmmastros]

Nope. You just learned a lesson.

Whenever you see "Too few parameters." the problem is a mispelled field name. There was a time when I got the same error and spent hours trying to figure out the cause.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom