Ayuda !! Urgente!! PW9 y Access
Publicado por Ernswolf (51 intervenciones) el 10/03/2010 17:23:31
Hola a todos, tengo un pequeño problema. Estoy haciendo unos reportes con una base de datos en access que ya estaba hecha, yo solo tengo q hacer los reportes...pero hay uno donde debo meter como argumento un rango de fecha, el cambo es de tipo Datetime, y no me deja asignarle los argumentos, lo puse asi....
SELECT userinfo.userid,
userinfo.badgenumber,
userinfo.title,
departments.deptid,
departments.deptname,
checkinout.userid,
checkinout.checktime,
checkinout.checktime as fecha ,
checkinout.checktype,
checkinout.verifycode,
checkinout.sensorid,
checkinout.workcode,
checkinout.sn
FROM checkinout,
departments,
userinfo
WHERE ( checkinout.userid = userinfo.userid ) and
( departments.deptid = userinfo.defaultdeptid ) and
( ( departments.deptid = :depto ) AND
( checkinout.checktime >= {ts :fecha1})and
( checkinout.checktime <= {ts '2010-03-05 23:59:59'})
)
order by userinfo.badgenumber,checkinout.checktime
SELECT userinfo.userid,
userinfo.badgenumber,
userinfo.title,
departments.deptid,
departments.deptname,
checkinout.userid,
checkinout.checktime,
checkinout.checktime as fecha ,
checkinout.checktype,
checkinout.verifycode,
checkinout.sensorid,
checkinout.workcode,
checkinout.sn
FROM checkinout,
departments,
userinfo
WHERE ( checkinout.userid = userinfo.userid ) and
( departments.deptid = userinfo.defaultdeptid ) and
( ( departments.deptid = :depto ) AND
( checkinout.checktime >= {ts :fecha1})and
( checkinout.checktime <= {ts '2010-03-05 23:59:59'})
)
order by userinfo.badgenumber,checkinout.checktime
Valora esta pregunta
0