SELECT DISTINCT IWTUSER_ALARMS.NAME, IWTUSER_ALARMS.AID, IWTUSER_ALARMS.DUR,
Int(CInt([DUR])/86400) AS DAYS, Int((CInt([DUR]) Mod 86400)/3600) AS HOURS,
Int(((CInt([DUR]) Mod 86400) Mod 3600)/360) AS MINUTES,
Int((((CInt([DUR]) Mod 86400) Mod 3600) Mod 360)/60) AS SECONDS
FROM IWTUSER_ALARMS
WHERE (((CDate(Format([IWTUSER_ALARMS].[ITIME],"0000-00-00 00:00:00 ")))>=Date()-10))
GROUP BY IWTUSER_ALARMS.NAME, IWTUSER_ALARMS.AID, IWTUSER_ALARMS.DUR,
CInt([DUR])/86400, CInt([DUR]) Mod 86400, (CInt([DUR]) Mod 86400) Mod 3600,
((CInt([DUR]) Mod 86400) Mod 3600) Mod 360
ORDER BY IWTUSER_ALARMS.DUR DESC;
mercredi 20 juillet 2016
I am getting an error saying "Overflow" in MS Access query when I try to use CDate
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire