data type mismatch in criteria expression

  • Thread starter Thread starter kalle
  • Start date Start date
K

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
 
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'"
 
Back
Top