Hi!
I and trying to summarize the hours worked by the 1st - 15th and the 16th - end of whatever month is entered in the parameter. I am not sure if I am on the right track at all but this is what I was trying to make work and the sql of the current query.
Code:
1st - 15th: IIF(Datepart("d",<=15,Sum([Hours]),0))
The above formula gives me an error so I had to take it out of the below SQL.
Code:
SELECT tbl_WorkSummary.EmployeeName, Sum(tbl_WorkSummary.[Hours]) AS [1st - 15th], Sum(tbl_WorkSummary.[Hours]) AS [16th - 31st]
FROM tbl_WorkSummary
WHERE (((tbl_WorkSummary.DateWorked) Between DateSerial(Year(Date()),[Enter month],1) And DateAdd("d",-1,DateAdd("m",1,DateSerial(Year(Date()),[Enter month],1)))))
GROUP BY tbl_WorkSummary.EmployeeName;
Thank you for your time and help!