Originally Posted by
ridders52
"Really helpful stuff I keep misunderstanding"
God, working with 2 different languages is messing me up. Getting syntax error.
TBLTNum is where the 0-23 are, saved as HNum.
the first query is QRYHoraEntrada, where "Hora" (from column "Hora de entrada") and "Cantidad" (from column "ID de incidente") are taken from the table DCEne2018. The raw data I'm working with.
Thus:
Code:
SELECT TBLTNum.HNum AS IncidentHour, Nz([ID de incidente],0) AS TotalIncidents FROM DCEne2018 LEFT JOIN QRYHoraEntrada ON TBLTNum.HNum = QRYHoraEntrada.Hora;
From:
Code:
SELECT tblHours.HourValue AS IncidentHour, Nz([Incidents],0) AS TotalIncidentsFROM tblHours LEFT JOIN qryCountIncidentsByHour ON tblHours.HourValue = qryCountIncidentsByHour.IncidentHour;
Is that FROM after TotalIncidents a different word? Or not?