1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| Nbr j : 1 [Employee Number] = 4682 And [Leave] = ' & lve & ' And [Date_Leave] = #2019-04-23# 0
..
Public Function nbJ(nP As Long, lve As String, d1 As Date)
Dim n As Long
Dim sSQL As String
sSQL = "[Employee Number] = " & nP & " And [Leave] = '& lve &' And [Date_Leave] = #" & Format(DateAdd("d", n, d1), "yyyy-mm-dd") & "#"
If Nz(DCount("*", "Employee_Data", sSQL)) = 1 Then
'--- jour pr?c?dent est contigu
nbJ = 0
Debug.Print "Nbr j 0:"; nbJ,
Else
'--- jour pr?c?dent n'est pas contigu
n = 0
While True
n = n + 1
sSQL = "[Employee Number] = " & nP & " And [Leave] = ' & lve & ' And [Date_Leave] = #" & Format(DateAdd("d", n, d1), "yyyy-mm-dd") & "#"
Debug.Print sSQL,
Debug.Print Nz(DCount("*", "Employee_Data", sSQL))
If Nz(DCount("*", "Employee_Data", sSQL)) = 0 Then
nbJ = n
Debug.Print "Nbr j :"; nbJ,
Exit Function
End If
Wend
End If
End Function |
Partager