openaccess/test/source/queries/r_FraisKm0.bas

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