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 ***

Use #4/1/2009# instead.

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


"kalle" wrote:

>
> 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 ***
>