1 2 3 4 5 6 7 8 9 10 11
|
Private Sub Report_Open(Cancel As Integer)
Dim strSQL As String
strSQL = "SELECT tbl_Journal.jou_Id, tbl_Vehicules.veh_Type, tbl_Sorte.sor_Sorte, tbl_Trafic.tra_Trafic, tbl_Lieu.lieu_Lieu, tbl_Journal.jou_DateDebut, tbl_Journal.jou_HeureDebut, tbl_Journal.jou_DateFin, tbl_Journal.jou_HeureFin, tbl_Journal.jou_Bis, tbl_Journal.jou_DpAvise, tbl_Journal.jou_NoVehicule, tbl_Journal.jou_NoSAP, tbl_Journal.jou_StatutSAP, tbl_Journal.jou_rep, tbl_Journal.jou_remarque, tbl_Journal.jou_CeresOkBis, tbl_Journal.jou_Suivi, tbl_Journal.jou_CeresOk, tbl_Journal.jou_Suppr, tbl_Journal.jou_Termine, tbl_Journal.jou_veh_Id, tbl_Journal.jou_sor_Id, tbl_Journal.jou_tra_Id, tbl_Journal.jou_lieu_Id "
strSQL = strSQL & "FROM tbl_Vehicules INNER JOIN (tbl_Trafic INNER JOIN (tbl_Sorte INNER JOIN (tbl_Lieu INNER JOIN tbl_Journal ON tbl_Lieu.lieu_Id = tbl_Journal.jou_lieu_Id) ON tbl_Sorte.sor_Id = tbl_Journal.jou_sor_Id) ON tbl_Trafic.tra_Id = tbl_Journal.jou_tra_Id) ON tbl_Vehicules.veh_Id = tbl_Journal.jou_veh_Id "
strSQL = strSQL & "WHERE (((tbl_Trafic.tra_Trafic)='Agenda FV') AND ((tbl_Journal.jou_DateDebut)=#1/12/2009#));"
DoCmd.RunSQL strSQL
End Sub |
Partager