access数据库删除问题，为什么删不掉？

[姜陈子]

select * from online where datediff('s',lasttime,now())>600
能查询出记录
但delete from online where datediff('s',now(),lasttime)>600
却删不掉记录

[Go 旅城通票]

--你前面的代码时间搞反了吧
--MSSQL
delete   from   online     where   datediff( 's',lasttime,getdate())> 600 

--access
delete   from   online     where   datediff('s',lasttime,date())> 600 

[XJY123]

delete from online where lasttime in (select lasttime datediff( 's ',now(),lasttime)> 600)
试试

[姜陈子]

不好意思
我时间写反了
该成
delete from online where datediff( 's ',lasttime,now())> 600
就行了