hour total, grouping or qry (1 Viewer)

mrrayj60

Registered User.
Local time
Today, 17:33
Joined
Sep 3, 2009
Messages
103
My report gives me the total records created by date. Manager wants to broken down by shift entries. My table has a field createtime. Ive tried toying with this grouping in the report but no luck. =DatePart("h",[createtime])

Using it in a query gives me zero records. Should I be looking into the report grouping to total the shifts? or queries? :confused:

Thanks, Ray Brookridge, Fla

date Shift (7 - 3 Shift) (3 -11 Shift) (11 - 7) Total Day
4/2/2012........................................................226
4/3/2012..........................................................91
4/4/2012..........................................................53
4/5/2012..........................................................71
4/6/2012..........................................................57
4/7/2012..........................................................89
4/8/2012........................................................140
4/9/2012..........................................................54
Total Records...............................................781
Page 1 of 1
 

Isskint

Slowly Developing
Local time
Today, 21:33
Joined
Apr 25, 2012
Messages
1,302
The way i would approach this is to have a seperate query for each shift (7-3 qryEarlies, 3-11 qryMids and 11-7 qryLates - assuming 7-3 is 07:00 to 15:00:p). In the createtime criteria use the start and end times of the shift to limit your results to the relevant shift EG
  • BETWEEN #07:00:00# AND #14:59:00# for the qryEarlies
  • BETWEEN #15:00:00# AND #22:59:00# for the qryMids
  • >#23:00:00# OR <#06:59# for the qryLates.
Then create 1 report based on each shift query. These reports will then be used as sub reports on a master shift report so you can show all shifts on 1 report for your manager.
 

mrrayj60

Registered User.
Local time
Today, 17:33
Joined
Sep 3, 2009
Messages
103
Thank you Isskint,
I created the reports for each shift using the # to get my shifts, thanks. I have never made a report that has other reports in them. I will browse the forum to locate that but if you get this can you point me in the direction, Thanks Again. Ray
 

Isskint

Slowly Developing
Local time
Today, 21:33
Joined
Apr 25, 2012
Messages
1,302
Ray it is just as simple as a normal report. Create a new unbound report (Reports>>Create Report in Design View). On the controls toolbar is a button for a Subform/Subreport. When you place this on your report it will ask you for the name of the sub report, just select the first shift report. Repeat for the other 2 shift reports. Then it is just a case of sizing and formatting the report appearance to be 'pleasing' on the eye.
 

mrrayj60

Registered User.
Local time
Today, 17:33
Joined
Sep 3, 2009
Messages
103
Isskint,
Well how about that a report in a report, great idea. Thanks for all your help. Looks great, works great. Thanks for all your help. Ray from Brookridge a homeowners association. :)
 

Attachments

  • GuardReport.doc
    22.5 KB · Views: 428

Users who are viewing this thread

Top Bottom