I have no idea why this query will not work
Update CrimesPerday
SET [Number of Crimes] = [Number of Crimes] +1
WHERE
IIf (WeekDay([Start Day])=Weekday([End Day]) and DATEDIFF('y',[start day],[end day])>=7), [CrimesPerDay].DayNum in (1,2,3,4,5,6,7), IIf WeekDay([StartDay]) > Weekday([End Day]), [CrimesPerday].DayNum between Weekday([Start Day]) and (7) or
[CrimesPerDay] between (1) and Weekday([End Day]), [CrimesPerDay].DayNum between weekday([Start Day]) and weekday([End Day]);
Any help would be greatly appreciated.
Thank you