Shift wise Totals

[Guest]

I have a shift 6 running after midnight, hence the productions shows on the
next day, can I have the production for the same day.
The shifts timings are shift 1 - 6am - 9am, shift 2 - 9:30am _12:30pm,
shift3 - 1pm - 4pm, shift 4 - 5pm-8pm, shift 5 - 8:30pm:1130pm, & shift6 -
00am - 2:30am
Thats the production for the day, but since shift 6 falls after midnight,
all that is process falls on the next day, while actually the production is
for the previous day.

 

[Michel Walsh]

Subtract, logically, 2h30 ?


SELECT ..., SUM( something) ,...
FROM ...
GROUP BY DateValue( dateTimeStamp - #02:30:00# )


Vanderghast, Access MVP

 

[John Spencer]

Darn it, I wanted to answer this by telling the poster that he should SHIFT
the datetime by subtracting 3 hours from the datetime field. Oh well,

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Michel Walsh]

It seems I got it before you by... half an hour, roughly


Vanderghast, Access MVP