Intentaría así:
Código SQL:
Ver originalSELECT FirstName,
LastName,
CAST(Fecha AS DATE) Fecha,
MIN(Iif(Description='Entrada',TimeStamp_Server,'29991231')) PrimeraEntrada,
MAX(Iif(Description='Salida',TimeStamp_Server,'19000101')) UltimaSalida
FROM Message
GROUP BY FirstName,
LastName,
CAST(Fecha AS DATE);