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 30 31 32 33
|
reqst = 0
reqhas = 0
passt = 0
pashas = 0
startdate = Mid$(Forms!choix_periode.lib_du.Value, 4, 2) & "/" & Mid$(Forms!choix_periode.lib_du.Value, 1, 2) & "/" & Mid$(Forms!choix_periode.lib_du.Value, 7, 4)
dateend = Mid(Forms!choix_periode.lib_au.Value, 4, 2) & "/" & Mid(Forms!choix_periode.lib_au.Value, 1, 2) & "/" & Mid(Forms!choix_periode.lib_au.Value, 7, 4)
' testé , pas vraiment correct :
'reqst = DCount("*", "Requerant", "localite = 'saint amand les eaux' and (([absent du] >= #" & startdate & "# or [absent du] <= #" & dateend & "#) and ([au] >= #" & startdate & "# and [au] <= #" & dateend & "#))")
reqst = DCount("*", "Requerant", "localite = 'saint amand les eaux' AND (((#" & startdate & "# BETWEEN [ABSENT DU] AND [AU]) OR (#" & dateend & "# BETWEEN [ABSENT DU] AND [AU])) OR (#" & startdate & "# < [ABSENT DU]) AND (#" & dateend & "# > [AU]))")
' testé , pas vraiment correct :
'reqhas = DCount("*", "Requerant", "localite = 'hasnon' and (([absent du] >= #" & startdate & "# or [absent du] <= #" & dateend & "#) and ([au] >= #" & startdate & "# and [au] <= #" & dateend & "#))")
reqhas = DCount("*", "Requerant", "localite = 'HASNON' AND (((#" & startdate & "# BETWEEN [ABSENT DU] AND [AU]) OR (#" & dateend & "# BETWEEN [ABSENT DU] AND [AU])) OR (#" & startdate & "# < [ABSENT DU]) AND (#" & dateend & "# > [AU]))")
'passt = DCount("date", "passage", "localite = 'SAINT AMAND LES EAUX' AND ([date] >= #" & startdate & "#) and ([date] <= #" & dateend & "#)")
'pashas = DCount("date", "passage", "localite = 'HASNON' AND ([date] >= #" & startdate & "#) and ([date] <= #" & dateend & "#)")
passt = DCount("date", "passage", "localite LIKE 'SAINT AMAND LES EAUX' AND ([date] between #" & startdate & "# and #" & dateend & "#)")
pashas = DCount("date", "passage", "localite LIKE 'HASNON' AND ([date] between #" & startdate & "# and #" & dateend & "#)")
pastotal = passt + pashas
reqtotal = reqst + reqhas
If (pastotal > 0 Or reqtotal > 0) Then
moyenne = Round((pastotal / reqtotal), 2)
Else
moyenne = 0
End If
Me.etik_periode.Caption = "Période du " & Forms!choix_periode.lib_du.Value & " au " & Forms!choix_periode.lib_au.Value |
Partager