How to transfers logic from Access SQL to below,
1. Select IIf(DLookUp("ServiceDate","sysUser")>=[ServiceDateStart] AND
[WeekDay]=Weekday(DLookUp("ServiceDate","sysUser"),2),1,0) AS ChkBusyRegular
From te
2. Select Weekday([ServiceDateStart],2) AS WeekDay
From te