The problem I have when keeping the time portion is pulling only 1 record for each shift/day. I’m using the Max() to sort through records with the same date. So, for week queries I’d like the max footage records for that day & shift.
The problem I have when keeping the time portion is pulling only 1 record for each shift/day. I’m using the Max() to sort through records with the same date. So, for week queries I’d like the max footage records for that day & shift.