Operation =1 Option =0 Having ="(((tbl_FormDep.MoisRH)=[Formulaires]![frm_menu].[Mois]) AND ((tbl_FormDep.AnneeR" "H)=[Formulaires]![frm_menu].[Annee]))" Begin InputTables Name ="tbl_FormDep" Name ="r_Agents" End Begin OutputColumns Expression ="tbl_FormDep.CodeAgent" Expression ="tbl_FormDep.MoisRH" Expression ="tbl_FormDep.AnneeRH" Alias ="SommeDeDistance2_perso" Expression ="Sum(tbl_FormDep.Distance2_perso)" Alias ="SommeDeDistance1_perso" Expression ="Sum(tbl_FormDep.Distance1_perso)" Alias ="DistanceMois" Expression ="Sum([Distance2_perso]+[Distance1_perso])" Expression ="r_Agents.TypeVehicule" Expression ="r_Agents.PuissanceFiscVP" End Begin Joins LeftTable ="r_Agents" RightTable ="tbl_FormDep" Expression ="r_Agents.CodeAgent = tbl_FormDep.CodeAgent" Flag =1 End Begin Groups Expression ="tbl_FormDep.CodeAgent" GroupLevel =0 Expression ="tbl_FormDep.MoisRH" GroupLevel =0 Expression ="tbl_FormDep.AnneeRH" GroupLevel =0 Expression ="r_Agents.TypeVehicule" GroupLevel =0 Expression ="r_Agents.PuissanceFiscVP" GroupLevel =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" ="r_Agents.PuissanceFiscVP" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.CodeAgent" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.MoisRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.AnneeRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="r_Agents.TypeVehicule" dbLong "AggregateType" ="-1" dbInteger "ColumnWidth" ="2205" dbBoolean "ColumnHidden" ="0" End Begin dbText "Name" ="DistanceMois" dbLong "AggregateType" ="-1" dbInteger "ColumnWidth" ="3105" dbBoolean "ColumnHidden" ="0" End Begin dbText "Name" ="SommeDeDistance2_perso" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="SommeDeDistance1_perso" dbLong "AggregateType" ="-1" End End Begin State =0 Left =0 Top =0 Right =1125 Bottom =545 Left =-1 Top =-1 Right =1109 Bottom =189 Left =0 Top =0 ColumnsShown =543 Begin Left =48 Top =12 Right =297 Bottom =353 Top =0 Name ="tbl_FormDep" Name ="" End Begin Left =338 Top =12 Right =582 Bottom =363 Top =0 Name ="r_Agents" Name ="" End End