Operation =1 Option =0 Where ="(((tbl_FormDep.Distance2_perso)<>0)) OR (((tbl_FormDep.Distance2_service)<>0)) O" "R (((tbl_FormDep.Distance1_perso)<>0)) OR (((tbl_FormDep.Repas)<>0))" Begin InputTables Name ="tbl_FormDep" Name ="r_Agents" End Begin OutputColumns Expression ="tbl_FormDep.CodeAgent" Expression ="r_Agents.Nom" Expression ="tbl_FormDep.JourRH" Expression ="tbl_FormDep.MoisRH" Expression ="tbl_FormDep.AnneeRH" Alias ="DateRH" Expression ="CDate([JourRH] & \"/\" & [MoisRH] & \"/\" & [AnneeRH])" Expression ="tbl_FormDep.Itineraire" Expression ="tbl_FormDep.Distance2_perso" Expression ="tbl_FormDep.Distance2_service" Expression ="tbl_FormDep.Distance1_perso" Expression ="tbl_FormDep.Repas" Alias ="Vehicule" Expression ="IIf(([Distance2_perso]+[Distance1_perso])>0,'VP',IIf([Distance2_service]>0,'VS'," "''))" Expression ="tbl_FormDep.Remarque" End Begin Joins LeftTable ="r_Agents" RightTable ="tbl_FormDep" Expression ="r_Agents.CodeAgent = tbl_FormDep.CodeAgent" Flag =1 End Begin OrderBy Expression ="r_Agents.Nom" Flag =0 End dbBoolean "ReturnsRecords" ="-1" dbInteger "ODBCTimeout" ="60" dbByte "RecordsetType" ="0" dbBoolean "OrderByOn" ="0" dbByte "Orientation" ="0" dbByte "DefaultView" ="2" dbBoolean "FilterOnLoad" ="0" dbBoolean "OrderByOnLoad" ="-1" dbBoolean "TotalsRow" ="0" Begin Begin dbText "Name" ="tbl_FormDep.CodeAgent" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.AnneeRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="DateRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.JourRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.MoisRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_Agents.Nom" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.Remarque" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.Itineraire" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.Distance2_perso" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.Distance2_service" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.Distance1_perso" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.Repas" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="Vehicule" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="r_Agents.Nom" dbLong "AggregateType" ="-1" End End Begin State =0 Left =0 Top =0 Right =956 Bottom =545 Left =-1 Top =-1 Right =940 Bottom =287 Left =0 Top =0 ColumnsShown =539 Begin Left =270 Top =12 Right =512 Bottom =291 Top =0 Name ="tbl_FormDep" Name ="" End Begin Left =52 Top =23 Right =242 Bottom =297 Top =0 Name ="r_Agents" Name ="" End End