mrrayj60
Registered User.
- Local time
- Today, 17:19
- 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?
Thanks, Ray Brookridge, Fla
date Shift (7 - 3 Shift) (3 -11 Shift) (11 - 7) Total Day
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
Using it in a query gives me zero records. Should I be looking into the report grouping to total the shifts? or queries?
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