Summarizing data by day range of selected month

[jbeets]

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.

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.

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!

[CJ_London]

try

sum(IIF(Datepart("d",dateworked)<=15,[Hours],0))

[jbeets]

You are the best! Thank you so much!