data type mismatch in criteria expression

[kalle]

Hi

I try to delete som records in an Access table but i can't find out how
to do it
The code below givs an error messages

data type mismatch in criteria expression

What is wrong?

"DELETE FROM table_name WHERE lastsaved < '2009-04-01'"

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***

 

[jasontferrell]

Use #4/1/2009# instead.

 

[joel]

Are Table_name and lastsaved variable.? then you have to break sht estrig
into pieces

from
"DELETE FROM table_name WHERE lastsaved < '2009-04-01'"


to
"DELETE FROM " & table_name & "WHERE " & lastsaved & "< '2009-04-01'"