Indentifying a payperiod

  • Thread starter Thread starter KWhamill
  • Start date Start date
K

KWhamill

I want to Sum the number of hrs A has worked in a pay period. I have a chart
that gives me the start and end date of the pay periods, and i have A's work
schedule. what I am trying to figure out is how to get access to identify the
correct pay period based on the dates.
 
Try this --
SELECT [Pay_Period].[WeekNUM], [Employee], Sum([Work Schedule].[WorkHours])
AS Pay_Period_Hours
FROM Pay_Period, [Work Schedule]
GROUP BY [Pay_Period].[WeekNUM], [Employee]
HAVING [Work Schedule].[Work_Day] Between [Pay_Period].[Start date] AND
[Pay_Period].[End Date];
 
Back
Top