X
x01kgb
Man, I really hate to ask... but
I created 4 queries that sum the total hours an employee worked by pay
period. The reason for 4 queries are because of different shifts. Now
depending on their status (full time, part time...) overtime is calculated by
adding the different shifts and excluding others toward the needed hours. So
I whipped up a new query thinking I knew what I was doing - specified one of
the shifts (say "FT") as some critera and proceeded to sum the needed sum's
of the other queries. Alas... I get nada but colum headings.
Here is the field in the query designer where I want the calculation:
Total FT Hours: Sum(([qrySum_PPHours_For_Dayshift].[Total Dayshift
Hours]+[qrySum_PPHours_For_NightsWeekends].[Total NightWeekend
Hours]+[tblHours_Per_Week].[PTO_Earned]+[tblHours_Per_Week].[Holiday]))
Anybody want to point me in a direction of solving this issue?
Pretty please with a cherry on top?
bright horizons....
x01kgb
I created 4 queries that sum the total hours an employee worked by pay
period. The reason for 4 queries are because of different shifts. Now
depending on their status (full time, part time...) overtime is calculated by
adding the different shifts and excluding others toward the needed hours. So
I whipped up a new query thinking I knew what I was doing - specified one of
the shifts (say "FT") as some critera and proceeded to sum the needed sum's
of the other queries. Alas... I get nada but colum headings.
Here is the field in the query designer where I want the calculation:
Total FT Hours: Sum(([qrySum_PPHours_For_Dayshift].[Total Dayshift
Hours]+[qrySum_PPHours_For_NightsWeekends].[Total NightWeekend
Hours]+[tblHours_Per_Week].[PTO_Earned]+[tblHours_Per_Week].[Holiday]))
Anybody want to point me in a direction of solving this issue?
Pretty please with a cherry on top?
bright horizons....
x01kgb