select Name,(select max(checktime) from checkinout,userinfo where checkinout.USERID=userinfo.USERID) as checktime,DEFAULTDEPTID,badgenumber from userinfo where userinfo.defaultdeptid in (1,6,8) group by Name,checktime order by checktime desc
参数 checktime 没有默认值。.' order by (case when checktime=null '''' else checktime end ) desc';这样写也不行
参数 checktime 没有默认值。.' order by (case when checktime=null '''' else checktime end ) desc';这样写也不行
Attendance Management Program
---------------------------
select Name,(select max(checktime) from checkinout,userinfo where checkinout.USERID=userinfo.USERID and checktype<>'O' and checktype<>'o' and checktime between #1899-12-30# and #1899-12-30#) as checktime,DEFAULTDEPTID,badgenumber from userinfo where userinfo.defaultdeptid in (1,6,8,11,13,7,9,10,9999999999999999) group by Name,checktime,DEFAULTDEPTID,badgenumber order by (case when checktime is null then cast(0 as datetime) else checktime end ) desc desc
---------------------------
OK
---------------------------
ACCESS里提示错误:未指定的错误.
DEFAULTDEPTID,badgenumber
from userinfo
where userinfo.defaultdeptid in (1,6,8)
order by 2 desc