David Smith

David Smith

  • NA
  • 2k
  • 0

Linq

Nov 20 2012 4:22 PM
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

Answers (1)