SELECT ., Format(., "dd.mm.yyyy") as , COunt() as FROM LEFT JOIN ON . = . GROUP BY ., Format(., "dd.mm.yyyy")
http://www.sql.ru/forum/1263355/poisk-progulyavshih-sotrudnikov