1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| Dim strSQL As String
Dim SN As String
Dim jour
jour = Date
jour = Format(jour, "mm/dd/yyyy")
jour = DateAdd("yyyy", -2, jour)
jour = Format(jour, "yyyyddmm")
SN = "0"
strSQL = "SELECT Count(*) AS nbr, T_Data.Family, T_Data.Market, T_Data.Model, T_Data.SN1, T_Data.SN2, T_Data.Instal " & _
"FROM T_Data " & _
"GROUP BY T_Data.Family, T_Data.Market, T_Data.Model, T_Data.SN1, T_Data.SN2, T_Data.Instal, T_Data.Period " & _
"HAVING (((Count(*))>1) AND ((T_Data.SN1)<>" & SN & ") AND ((T_Data.SN2)<>" & SN & ") AND ((T_Data.Period)>" & jour & ")) " & _
"ORDER BY Count(*) DESC;" |
Partager